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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Cell A1 = Shawnee
Cell B1 = Mission

Answer in Cell C1

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

HTH
 
Back
Top