Basic concatenate question

[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.

 

[Frank Kabel]

Hi
try
=A1 & "," & B1 & "," & C1

Frank

 

[Norman Harker]

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.

 

[JG]

Thanks I'm back on track!

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.