| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
Data-'Text to Columns'-Choose Delimited and select the appropriate delimiter
-- Regards, Dave "Kelvin Lee" wrote: Let say in 'A1' I input as "AARON WONG". How to make it to 'B1' as "AARON" and 'B2' as "WONG"? And Let say the text in 'A1' as "BCBB123456-IP SEMINAR". How to make it to 'B1' as "BCBB123456" then 'B2' as "-IP SEMINAR"? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Killing the split window | Setting up and Configuration of Excel | |||
| How do I split a cell of 2 words into two cells | Excel Worksheet Functions | |||
| triadic combinations of words | Excel Worksheet Functions | |||
| Spell Checking - Special Words Not Picked Up by Excel | Excel Discussion (Misc queries) | |||
| Creating a Microsoft Words document from an existing Excel spreads | New Users to Excel | |||
Threaded Mode
