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:E1...
excel
Formulas and Functions
  • Matt Mickle's avatar
    Matt Mickle
    Mar 21, 2019

    Sentri1420 

     

    Maybe try this:

     

     

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

     

     

     

     

     

     

     

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

Resources