Multiple text to 2 columns

Closed
Bruce427 - Apr 17, 2010 at 07:20 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Apr 17, 2010 at 07:51 AM
I need to divide the text in Column A into Column A & B. Each cell in Column A has a different number of text items. A1 might say "John A Smith is here." A2 might say "The dog is here." I only want to put the FIRST word of each cell in Column A; the rest of the words in Column B. In this case, A1 would be "John"; B1 would be "A Smith is here." A2 would be "The" and B2 would be "dog is here"

How do I do that?

Thanks.

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Apr 17, 2010 at 07:51 AM
If your data is in cell A1 and first word is to be on cell b1 and rest in c1 then in B1 use this

=IF(ISERROR(FIND(" ",A1,1)), A1, LEFT(A4,FIND(" ",A1,1)-1))


and in C1 use

=IF(ISERROR(FIND(" ",A1,1)), "", MID(A1,FIND(" ",A1,1)+1,LEN(A1)))
0