Removing Spaces

[tagman]

Is there any way to easily remove spaces between words? I have a dataset consisting of names and surnames without spaces and I want to transfer information to another sheet that has the names with spaces. I suppose conversely is there an easy way of splitting the un-spaced data.

Excel 2003

 

[Trouttrap2]

You could highlight your data set and use the Find and Replace feature built in Excel. CTL+F then enter a space in the Find What, then leave Replace with blank.

 

[tagman]

Trouttrap2, you genius. That has to be filed under 'Why didn't I think of that'!! Thank you.