Recent content by delange
-
D
Separate single address field into house number and street address
How can I remove the alpha text to the (right) preceding the first instance of a number.... Ex Center Base 9600 Drive Ln Center West 6600 Davis st Quest Center 8500 Lyn Ave I want only the street address returned for each cell 9600 Drive Ln 6600 Davis st 8500 Lyn Ave thanks -
D
Separate single address field into house number and street address
Hi Brian... I know you post is very old... I hope you or someone else can assist. I used your code and it works perfect however. I need to have the address parsed into 3 sections ...ex client home 9678 gremlin circle, Hampton VA 23111 I need it to be split into 5 columns splitting like so...