Separate State

[franknove]

I have a field which contains Suburb and State. Sometimes suburb can be one, two or three words, and state is 2 or 3 letters.

I would like to separate suburb. I have managed to pull out state using "rightword".

[LaRetta]

For the suburb, you might try:

LeftWords ( yourField ; WordCount ( yourField ) - 1 )