Split address field into separate columns in Excel(4 posts)
There are 3 ways to do the task which I know of.
1. Re-enter the data manually.
2. Make complicated formulas in other cells.
3. Write a macro.
Best bet, with that much info to transform, is get a good book on Excel.
One of our members may have had to do this before since it is a very, very common error, so maybe they will respond with the formula or macro they used so you can started.
Rick P.♦ :)
This topic has been closed to new replies. Please create a new topic instead.