Getting a string out of numbers!

[bomayed]

If I have this line : 3233 Washington D.C

and I want to get only the string in that line which is "Washington D.C" How do I do that?

 

[btaber]

Instr returns the position of the first ocurance in a string, so we find the first space, add one to it (to omit the space), and use mid to get part of the string

Address = "3233 Washington D.C"
Street = Mid(Address, InStr(1, Address, " ") + 1, Len(Address))
Debug.Print Street