String

  • Thread starter Thread starter Kevin Carter
  • Start date Start date
K

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
 
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
Click to expand...

after import run TextToColumns


Regards
Claus Busch
 
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
Click to expand...

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