Multiple text to 2 columns

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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)))