|
|
#3
09-17-2011, 05:38 AM
|
|||
|
|||
well, there is a method, very easy:
select your range to split, then on Data tab, Data instruments-text to column.... folow the menu, and select your separator.. in you case, it' s a space.. your range is now separated in next columns, each word or numbers in a column 
|
|
|
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 Vista 
Office 2007
Threaded Mode