Mar 21 2019 10:27 AM
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??
Mar 21 2019 10:49 AM
SolutionMar 21 2019 11:37 AM
Mar 21 2019 10:49 AM
Solution
Maybe try this:
You can add Prefixes with custom formatting as well....