Basic concatenate question

  • Thread starter Thread starter JG
  • Start date Start date
J

JG

I have 3 columns of over 900 rows of numbers. I need to combine each rows
numbers with comma separated.

Example
123 456 789 needs to be 123,456,789

I tried =A1&B1&C1 but this will not give me a comma separated number.

Thank you for any help you can give.
 
Hi JG!

If it's a number you want:

=--(A1&B1&C1)

Format as a number using 1000 separator.

If it's text you want:

=A1&","&B1&","&C1
Or:
=TEXT(A1&B1&C1,"###,###,###")

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Thanks I'm back on track!


Norman Harker said:
Hi JG!

If it's a number you want:

=--(A1&B1&C1)

Format as a number using 1000 separator.

If it's text you want:

=A1&","&B1&","&C1
Or:
=TEXT(A1&B1&C1,"###,###,###")

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Click to expand...
 
Back
Top