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 ...
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
- Can you post your workbook? Or an example of the data you are trying to combine with the formula you are trying to use?
