Thread: Split the words
View Single Post
  #1   Report Post  
Kelvin Lee
 
Posts: n/a
Default 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"?