|
|
#1
09-16-2011, 11:11 AM
|
|||
|
|||
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. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How can I fill the below emty cells with above cell data? | Learner7 | Excel | 8 | 06-28-2011 12:10 PM |
| Move data from 1 cell to another cell | Catalin.B | Excel | 1 | 06-25-2011 12:51 PM |
 How to combine different cells data in one cell?
|
Learner7 | Excel | 1 | 07-28-2010 12:07 PM |
| Displaying cell data in another spreadsheet | Colonel Biggs | Excel | 0 | 07-01-2010 07:37 PM |
|
Copying data from one cell to another automatically
|
mrphilk | Excel | 4 | 06-10-2010 11:52 PM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode