Splitting text srtings automatically

  • Thread starter Thread starter shartman
  • Start date Start date
S

shartman

I have a column that holds text strings no longer than 18 characters
(including spaces) long. Is there a function that I can use to split the
data into 2 columns that hold 9 characters each but not break up individual
words? An IF statement using MID and LEN gets close but not close enough.
Thanks in advance for any help

ex.

Column A Column B Column C
Harveys Bristol Harveys Bristol
Harvest Lite Harvest Lite
 
shartman,

The 9 characters each has me confused????
You can easily do that with the left and right functions.

If youre trying to split them on the space, the following should work:

For the left word:
=LEFT(A1,FIND(" ",A1)-1)

For the right word:
=MID(A1,FIND(" ",A1)+1,LEN(A1))

John
 
First name:

=LEFT(A1,FIND(" ",A1)-1)

Second name:

=MID(A1,FIND(" ",A1)+1,255)

HTH
Jason
Atlanta, GA
 
What happens if you have a word longer than 9 characters, or perhaps 3 words eg
5char_6char_5char

You cannot break that into 2 cols of no more than 9 without breaking a word.
 
Back
Top