Split the words

K

Kelvin Lee

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"?
 
D

David Billigmeier

Data->'Text to Columns'->Choose Delimited and select the appropriate delimiter
 
Top