I've got an Excel spreadsheet that I'm working on, and I'm stuck with this problem.
This is the current formula for one of the cells:
=CONCATENATE($A$32,"",$B$32,"",$C$32,"",$D$45)
All the data is auto filled and pulled from other cells located in A32
, B32
, C32
and D45
, etc.
I would like to add some commas in between data for it to be easier to process later on.
I came up with this:
=CONCATENATE($A$32,"**,**",$B$32,"**,**",$C$32,"**,**",$D$45)
However, I can't find for the life of me how to apply THAT change to all the other columns in the spreadsheet.
I've tried Ctrl+drag, Alt+drag, but nothing works.
Can anyone help please?