place data located in 2 columns in to 1 col seporated by a space

N

ntatesteve

i need to place data located in 2 columns in to 1 col seporated by a space.
The rev of text to columns. If this is done with "consolidate" then i do not
understand how to do it.
example
col C = Shawnee, col D = Mission
i want "Shawnee Mission" in a single col

I am using Excel 2003 SP2
 
P

Peo Sjoblom

Use a help column

=C2&" "&D2

copy down, copy the new column and paste special as values in place, finally
you can delete the original 2 columns if you need to
 
S

steve_doc

Assuming

Cell A1 = Shawnee
Cell B1 = Mission

Answer in Cell C1

In C1 type the following formula "=CONCATENATE(A1," ",B1)

HTH
 
Top