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


--
Regards,

Peo Sjoblom

"ntatesteve" wrote in message
...
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