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