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 …

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 …

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

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 …

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...

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?

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 …

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.

Apr 25, 2006 · I am trying to export an .xls file to a .txt file. I can export the .xls file to a .txt file, but I am having trouble entering the Tab Space between each column. I tried adding spaces, …