selecting part of a field after a blank space

K

kim

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.
 
A

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))
 
K

kim

Thank you very much!

Allen Browne said:
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.

kim said:
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.
Click to expand...
Click to expand...
 
Top