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