There has to be an easier way to clean up address data, I hope?
GeoCoding, I need to remove APT# and any number or letter that follows.
You could give this a try:
for 10221 Yukon Ave Apt#5, it returns: 10221 Yukon Ave
or if you want them all uppercase:
for 10221 Yukon Ave Apt#5, it returns: 10221 YUKON AVE
Of course this will not work in all situations. For example, if you have a street called 1000 Aptitude Dr, it would mess up and return just 1000. I added a space infront of "apt" for the split. This way it will not fail on, for example, 1000 Captive St.