MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Spaces in cells


Posted by Ronnie on November 16, 2001 7:34 AM

Hello there.......

I have a problem where I have a list of individual's names in cells. The problem is, the forename and surname have been placed in the same cell and I want to be able to separate them into different cells. Is there a way I can do this?

Hope you can help (liked the tip on index and match, by the way - very useful)

Thanks

Ronnie


Posted by Mark W. on November 16, 2001 7:39 AM

Use the Data | Text to Columns... menu command.