I have inherited a spreadsheet that has data as follows:
Cell A1 Cell B1 Cell C1
ABC Company <blank> 440-444-1234
1234 Main Street, Cleveland, OH 44123
For each record, I need to move the address info over one cell to the right and up one cell (to cell B1 in this example). I'm trying to write a macro to do this but haven't figured it out. Any hints would be appreciated.