ExcelBanter - Split the words

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Split the words (https://www.excelbanter.com/excel-discussion-misc-queries/49596-split-words.html)

Kelvin Lee

Split the words

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

David Billigmeier

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

All times are GMT +1. The time now is 10:49 PM.