Strip Right Side String 1

[cabobound]

Im trying to spread a city/state field in two. How do I do this with VBA?


n![City] = rst![Optional City/State]

Where rst![Optional City/State]="CHICAGO IL"

 

[Bong]

<State> = right(<string>,2)
<City> = left(<string>,len(<string>)-3)

_________________
Bob Rashkin

 

[SkipVought]

Hi,

Check out the Data > Text to columns... spreadsheet feature

Skip,

_{I'll be dressed to the nines this week, as I go to have my prostatectomy...
Because, if I'm gonna BE impotent, I want to LOOK impotent!}

 

[SkipVought]

..or Rightstring, 2), Left(string, len(string)-3)

Skip,

_{I'll be dressed to the nines this week, as I go to have my prostatectomy...
Because, if I'm gonna BE impotent, I want to LOOK impotent!}

 

[SkipVought]

..or Right(string, 2), Left(string, len(string)-3)

Skip,

_{I'll be dressed to the nines this week, as I go to have my prostatectomy...
Because, if I'm gonna BE impotent, I want to LOOK impotent!}

 

[cabobound]

Thanks for the hit Bong LOL