Forum Discussion
Combining text without losing data
I have 10 columns of data that need to be combined into one column with a comma and no space between any of them for a CSV format requirement.
AKA:
words,words,words, and so on.
I cannot get the ampersand or the concat formula to work. Any advice?
4 Replies
What does it do when you try.. the format should look something like this:
=CONCATENATE(A1,",",B1,",",C1)
Only with the 10columns.. =A1 & "," & B1 & "," ..... etc should work as well
That doesn't work. it gives me a REF error or a NAME error, or just gives me 10 commas then one link.
Formulas Philip suggested are definitely work, here is some other reason
