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