Splitting strings

[x0reset]

I am normalizing data from a spreadsheet of just over 4000 records. The spreadsheet has a "Model" field that contains both the model number and a model description, separated by a space. I would like to split this field into two different fields: "Model_Number" and "Model_Description". The model number is one word of varying lenths.

Any ideas?

 

[KenHigg]

Hum... Use InStr find the postion of the space, then use that with the right and left functions to split the string...

Would this work?

 

[Kodo]

not necessary.
use the split function instead.

 

[x0reset]

I can't seem to find the correct syntax for the split function. Think you could post an example for me?

Thanks!

 

[x0reset]

Hey Ken, your method works like a charm! Thanks much!

 

[Kodo]

varArray=split(variable,"string to split on")
now it's in an array..