reformat address info
Posted by James King on July 16, 2001 9:00 PM
I have several excel files that contain address information in the following format:
I want to reformat the information so Column A is Name, Column B is Address and Column C is City. Currently, I am cutting and pasting from the rows to the columns but it takes too much time. Is there a way to automate this reformatting? I tried to record a macro, my first time, but the macro was specific to the cells I was reformatting. If I could position the cursor in a cell and run a macro from there, that would be a step in the right direction. I hope my request is clear. Thanks for any help.