Understood, however the data I'm working with has 18,000 records in the format without the space! Is there perhaps a macro I could use that would search out and separate the numeric and alpha data? It would only apply to the beginning of the string because I could very well have an address that looks like this: 123Hwy37E Thanks in advance!
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
