INDIRECT and CONCATENATE with dynamic Cell reference
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 it …
CONCATENATE within a SUM forumla | MrExcel Message Board
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... ="B"&RIGHT …
How to use CONCATENATE and SUBSTITUTE formula together?
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...
Concatenating a cell reference - Excel Formulas - Board Archive ...
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
how to use concatenate and round function in one formula
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 there any want …
Concatenate Tab Name into a Formula - MrExcel
Aug 18, 2008 · Hello All: Can anyone help with this issue? I am trying to write a formula that will Concatenate the Tab name in order to get a value from that specific tab. Nutshell: I have a tab called …
BOLDING and UNDERLINING CONCATENATED CELLS - MrExcel
Feb 7, 2006 · I need help bolding and underlining cells that are "Concatenated". For example, cell format for cell K12 is already bolded and underlined. If I concatenate (C1,K12,D2) I get a result that doesn't …
Concatenate with Index & Match | MrExcel Message Board
Mar 9, 2014 · Evening all Is there a way to concatenate to columns (last name - Column A first name - Column B) with Index & Match. Example Sheet1 Last Name First...
How to keep the text permanently after applying Concatenate function
Dec 18, 2010 · I have joined two columns of text using =CONCATENATE(H2,", ",I2) Now, the J column has my desired result. How to delete column H and I and still keep the combined text in column J?
Concatenate filtered column values | MrExcel Message Board
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 around for a …