String

[Kevin Carter]

Hi
I am importing data from another package
the Srting is imported as : 1 one two three servername.com
the length of each word can change
what i would like to do is read the string and return
the first word in one cell, second word in another cell, third word retuned in another cell

how can i do this


thanks

kevin

 

[Claus Busch]

Hi Kevin,

Am Wed, 26 Jun 2013 02:59:47 -0700 (PDT) schrieb Kevin Carter:

I am importing data from another package
the Srting is imported as : 1 one two three servername.com
the length of each word can change
what i would like to do is read the string and return
the first word in one cell, second word in another cell, third word retuned in another cell

after import run TextToColumns


Regards
Claus Busch

 

[Kevin Carter]

Hi I am importing data from another package the Srting is imported as : 1one two three servername.com the length of each word can change what i would like to do is read the string and return the first word in one cell, second word in another cell, third word retuned in another cell how can i do this thanks kevin

thank you very much didnt know that tool was there
works a treat
kevin