how to combine numbers with the comma

[Guest]

How to combined the numbers with the comma

For eg: I have 123 in Cell A1 and I have 456 in Cell A2.

My result should be 123,456 this I can use of concatenate but this is a
long procedure to follow in case if I have N number of lines.

I have 200 lines like this to join with the comma, help me with the formula
on this at the earliest.

 

[jiwolf]

if you just want the value, then in the target cell enter =A1&","&A2

 

[Pete_UK]

Enter this formula in B1:

=""&A1

and this in B2:

=B1&","&A2

Position the cursor on cell B2 and double-click the fill handle (the
small black square at the bottom right corner of the cursor) - this
will copy the formula down and in your bottom row you should see all
the numbers joined together separated by a comma.

Hope this helps.

Pete

 

[Guest]

This I can do only for one or two cells if I have, I need to do for 200
lines then doing manually one by one is not possible.

 

[jiwolf]

just drag it down?

Enter this formula in B1:

=""&A1

and this in B2:

=B1&","&A2

Position the cursor on cell B2 and double-click the fill handle (the
small black square at the bottom right corner of the cursor) - this
will copy the formula down and in your bottom row you should see all
the numbers joined together separated by a comma.

Hope this helps.

Pete

 

[Guest]

Select your range > right click to Copy > Paste it into NotePad > Copy from
NotePad >select a blank cell and Paste it into a formula bar not directly
into a blank cell > click Enter > Edit > Replace > Find what: press a space
bar > Replace with: , > click Replace

 

[Pete_UK]

Yes, so that in B3 you will get:

=B2&","&A3

and in B4:

=B3&","&A4

so that the current value in A gets joined on to the previous values
in B.

Pete

 

[Herbert Seidenberg]

Since the data is in a column,
shouldn't it be: Find what: ~ ENTER
instead of: press space bar?