Merge columns

[CandiC]

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

 

[Pete_UK]

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

 

[pogiman via OfficeKB.com]

Try this in column D:

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

 

[Brad]

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

 

[CandiC]

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?

 

[CandiC]

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

 

[Pete_UK]

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

Pete