Thread: [Solved] Split Data from One Cell Into Two
View Single Post
 
Old 09-16-2011, 11:11 AM
Karen615 Karen615 is offline Windows 7 64bit Office 2010 64bit
Competent Performer
  
Join Date: Jun 2011
Location: Chicago
Posts: 145
Karen615 is on a distinguished road
Red face Split Data from One Cell Into Two
I have a cell that has the following data:
For example: (a 3-digit number and then a name)

123 Robert
234 Bill
456 Jane
342 Sue

I want to be able to separate the numbers into one cell and the name into another. Using Excel 2010, how can this be done?

Your help is greatly appreciated.
Reply With Quote