Previous Topic Next Topic

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

Answer 1 / 1
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
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