I have three columns that are phone numbers which got separated in a
download, can someone please help me merge this data back into one column so
the phone number reads like 5638433829 ?

A.............B..............C
(563 843 3829
(563 940 356
(563 940 3572
(563 940 5989
(563 940 7232
(563 940 7863
(563 940 8125
(563 343 4223
(563 370 2535

Put this in D1:

=TRIM(RIGHT(A1,LEN(A1)-1)&B1&C1)

This will give you a text result, but if you need it as a proper
number (for formatting) you can do this:

=--TRIM(RIGHT(A1,LEN(A1)-1)&B1&C1)

Copy it down, then fix the values and you could then get rid of the
original columns.

Hope this helps.

Pete

On Aug 28, 6:54*pm, CandiC wrote:
I have three columns that are phone numbers which got separated in a
download, can someone please help me merge this data back into one column so
the phone number reads like 5638433829 ?

* A.............B..............C
(563 * *843 * * 3829
(563 * *940 * * 356
(563 * *940 * * 3572
(563 * *940 * * 5989
(563 * *940 * * 7232
(563 * *940 * * 7863
(563 * *940 * * 8125
(563 * *343 * * 4223
(563 * *370 * * 2535

Try this in column D:

=Concatenate(A,B,C)
OR
=A&B&C



CandiC wrote:
I have three columns that are phone numbers which got separated in a
download, can someone please help me merge this data back into one column so
the phone number reads like 5638433829 ?

A.............B..............C
(563 843 3829
(563 940 356
(563 940 3572
(563 940 5989
(563 940 7232
(563 940 7863
(563 940 8125
(563 343 4223
(563 370 2535

--
Message posted via http://www.officekb.com

if you take a look at your second line I believe that 356 should be 0356
If you don't want to to have the starting "("
starting in D1

=mid(a1,2,3)&right("000"&b1,3)&right("0000"&c1,4)

copy down as needed....
--
Wag more, bark less


"CandiC" wrote:

I have three columns that are phone numbers which got separated in a
download, can someone please help me merge this data back into one column so
the phone number reads like 5638433829 ?

A.............B..............C
(563 843 3829
(563 940 356
(563 940 3572
(563 940 5989
(563 940 7232
(563 940 7863
(563 940 8125
(563 343 4223
(563 370 2535

I am trying to get this formula to work, for instance I have my information
in columns H380, I380 and J380, so in column K I have the Concatenate formula
set as, =Concatenate(H380,I380,J380) and it will not do anything. I don't
even get an error message. Can you please help me determine what I may be
doing wrong?

"pogiman via OfficeKB.com" wrote:

Try this in column D:

=Concatenate(A,B,C)
OR
=A&B&C



CandiC wrote:
I have three columns that are phone numbers which got separated in a
download, can someone please help me merge this data back into one column so
the phone number reads like 5638433829 ?

A.............B..............C
(563 843 3829
(563 940 356
(563 940 3572
(563 940 5989
(563 940 7232
(563 940 7863
(563 940 8125
(563 343 4223
(563 370 2535

--
Message posted via http://www.officekb.com

THis worked!!! Thank you so much for your help. Candi.

"Pete_UK" wrote:

Put this in D1:

=TRIM(RIGHT(A1,LEN(A1)-1)&B1&C1)

This will give you a text result, but if you need it as a proper
number (for formatting) you can do this:

=--TRIM(RIGHT(A1,LEN(A1)-1)&B1&C1)

Copy it down, then fix the values and you could then get rid of the
original columns.

Hope this helps.

Pete

On Aug 28, 6:54 pm, CandiC wrote:
I have three columns that are phone numbers which got separated in a
download, can someone please help me merge this data back into one column so
the phone number reads like 5638433829 ?

A.............B..............C
(563 843 3829
(563 940 356
(563 940 3572
(563 940 5989
(563 940 7232
(563 940 7863
(563 940 8125
(563 343 4223
(563 370 2535

You're welcome, Candi - thanks for feeding back.

Pete

On Aug 31, 3:09*pm, CandiC wrote:
THis worked!!! Thank you so much for your help. Candi.



"Pete_UK" wrote:
Put this in D1:

=TRIM(RIGHT(A1,LEN(A1)-1)&B1&C1)

This will give you a text result, but if you need it as a proper
number (for formatting) you can do this:

=--TRIM(RIGHT(A1,LEN(A1)-1)&B1&C1)

Copy it down, then fix the values and you could then get rid of the
original columns.

Hope this helps.

Pete

On Aug 28, 6:54 pm, CandiC wrote:
I have three columns that are phone numbers which got separated in a
download, can someone please help me merge this data back into one column so
the phone number reads like 5638433829 ?

* A.............B..............C
(563 * *843 * * 3829
(563 * *940 * * 356
(563 * *940 * * 3572
(563 * *940 * * 5989
(563 * *940 * * 7232
(563 * *940 * * 7863
(563 * *940 * * 8125
(563 * *343 * * 4223
(563 * *370 * * 2535- Hide quoted text -

- Show quoted text -