Excel 2007 Macro to Split 2 Lines of text In One Cell to Two Cells
Please see attached sample. I would like a macro, or other recommendations, on how to split out the data in column A so that the 1st address is in one column and the 2nd address is in another column. Addresses are just samples but there will be variance in length of addresses (longer street, city names, etc.).