Nov 26, 2011 · in call A1 i have value i enter in A1 is =2/3 and in A2 =CONCATENATE(A1,"x") which gives this value =0.666666666666667x but i want only 2 value after decimal + "x" is …

Dec 4, 2000 · Concatenating a cell reference Home Board Archive Index Excel Formulas Concatenating a cell reference Posted by Ron on December 04, 2000 12:48 PM

Apr 14, 2017 · I use match array function to figure out which column I need to pull (I can pull both number or column letter) but I don't know how to replace that to the Cell function and still make …

May 26, 2009 · Hi All, I'd like to be able to be able to filter a column, and have the filtered values be concatenated in a cell (I1, for example), separated by a semi-colon. I've been searching …

Jun 3, 2011 · First off, you do not need to use the CONCATENATE function, just link your items together with an ampersand. Your posted CONCATENATE formula can be written like this...

Jan 31, 2017 · Formula: =CONCATENATE(L1 & " Adjustments (2) ") Output: 2017 Adjustments (2) I would like to have (2) display as a superscript. Is there a way to do that?

Mar 27, 2013 · Live Online Excel Training for Your Team from MrExcel. Bring MrExcel to your people. Two hours. High-impact. Zero travel. Click here for details.

Nov 1, 2009 · Is this possible because when i try to use the Substitute formula my Concatenate formula is doesn't work. This data in cell A1 is linked from another sheet...

Jul 14, 2009 · concatenating formulas and getting thousand separators Chelrie Jul 14, 2009 comma separating concatenate formula functions C

Jan 2, 2005 · Hello again. I recently received help splitting one column into two using the DATA>TEXT TO COLUMNS>DELIMITED ability. I have now found myself wanting to combine …