![]() User1282637 asks if there is a way to accomplish this task and requests any help in doing that. I do hope this at least teaches you some ideas of how to go about this. Also if you want a more clean option then definitely look into learning about VBA more. Now I haven't done the city and state but following this idea, you can achieve this. Next I need to find how long the string is that is the street suffix so I use the following:Īnd lastly this allows me to display just the street: I display what is remaining because in your case "Courts" from "Basketball Courts" is also a street suffix: I separate the (Basketball Courts) part by using the parenthesis: It will simply list a number in the corresponding row that finds a match for the suffix used. This part could be done many ways but I decided on this way for an example. Next it is simply looking up what applies. I used the formula that I listed simply to convert the list to start with a capital letter and then the rest be lower case, like how you had yours written. One was all of the state abbreviations and the other being all the accepted street suffexes which I found here: I have only made it to be a starting point so you can finish with your own complete answer.įirst, I set up two lists. ![]() User1282637, I have set up an example to show you below.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |