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

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