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??
View best response
Maybe try this:
You can add Prefixes with custom formatting as well....