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.

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


"Igneshwara reddy" wrote in
message ...
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.

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

On Mar 5, 7:41 pm, Igneshwara reddy
wrote:
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.

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" wrote:

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


"Igneshwara reddy" wrote in
message ...
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.

just drag it down?

"Pete_UK" wrote in message
oups.com...
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

On Mar 5, 7:41 pm, Igneshwara reddy
wrote:
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.

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


"Igneshwara reddy" wrote:

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.

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

On Mar 5, 9:05 pm, "jiwolf" wrote:
just drag it down?

"Pete_UK" wrote in message

oups.com...



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

On Mar 5, 7:41 pm, Igneshwara reddy
wrote:
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.- Hide quoted text -

- Show quoted text -

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