Forum Discussion

Sentri1420's avatar
Sentri1420
Copper Contributor
Mar 21, 2019
Solved

Using CONCAT or TEXTJOIN to add a prefix and suffix to a column of data

I am attempting to add a prefix (Column C) and a suffix (Column E) to data from a column (Column D). This is the formula I've been playing with and trying to get to work:

 

=C7:C12&D7:D12&"-"&E7:E12      I also tried =(C7:C12)&(D7:D12)&"-"&(E7:E12) 

 

This formula is giving me the correct data stream in the first cell of the column but it doesn't populate apply the formula to the rest of the column. See attached picture.

 

I know there's a way to do this, any help??

 

 

 

excel
Formulas and Functions

2 Replies

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    Mar 21, 2019
    Concatenate the cells, rather than the ranges, like this:
    =C7&D7&E7
  • Matt Mickle's avatar
    Matt Mickle
    Bronze Contributor
    Mar 21, 2019

    Sentri1420 

     

    Maybe try this:

     

     

    You can add Prefixes with custom formatting as well....

     

     

     

     

     

     

     

Resources