selecting part of a field after a blank space

[Guest]

I'm trying to select a street name from the address field containing both the
address numbers as well as the street name. 1234 32nd Street, or 45697
Harold Drive. I want to extract the 32nd Street or Harold Drive so
everything after the first blank space. I hope that's clear! Any help would
be appreciated. Thanks in advance.

 

[Allen Browne]

Use Instr() to locate the first space, and Mid() to get all the remaining
text

Rough example:
Trim(Mid([Address], Instr([Address], " ")+1))

 

[Guest]

Thank you very much!

Use Instr() to locate the first space, and Mid() to get all the remaining
text

Rough example:
Trim(Mid([Address], Instr([Address], " ")+1))

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I'm trying to select a street name from the address field containing both
the
address numbers as well as the street name. 1234 32nd Street, or 45697
Harold Drive. I want to extract the 32nd Street or Harold Drive so
everything after the first blank space. I hope that's clear! Any help
would
be appreciated. Thanks in advance.