Is there even a formula for this!?

[josephryanchan]

Hey guys,

I need some help. I have a huge document that needs to be reformatted. I don't want to copy & paste to match the new format. I have attached in the following excel file of what I want.
Let me know if there is a formula to do that or if I will have to copy & paste everything..

Alternate between BEFORE & AFTER tabs.

Thanks

[daffodil11]

I would first recommend retitling your post to something in line with what you're looking for.

Does your raw data have any commonalities?
Are all roadways abbreviated?

They certainly don't all seem to have commas, so using that as a delimiter seems out of the questions. The only identifying characteristics would be Postal Code, Province abbreviation, and leading address numbers.

[arlu1201]

Thanks daffodil11.

Josephryanchan,

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.