I have a list of 250,000 addresses. The street name field sometimes includes a direction letter as the first character such as N,S,E,W. I want to remove these single characters and then move the rest of the address to the left. Moving the text is easy. I can't understand how to remove the first letter when followed by a blank.
Example:
S CAPISTRANO DR
KINGSRIDGE DR
S CAPISTRANO DR
BREMERTON CT
In this example, I want to remove the "S".
Bookmarks