Merge columns

  • Thread starter Thread starter CandiC
  • Start date Start date
C

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
 
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
 
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....
 
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?
 
Back
Top