TrippyTom
10-12-2011, 04:29 PM
Hi gang,
(please see attached sample data)
I have a very long list of addresses, and the city/state/zip are in ONE cell (which is ok) but they're falling under different columns all over the place.
Is there a quick way to shift the cells to the right so at least the city/state/zip is all in the same column?
I'm not sure of the best way to handle this. I was thinking of maybe offsetting each row by the number of blank cells in the "Address" columns, but that would require vba I think.
If there's an easier way I'd appreciate a tip. :)
(please see attached sample data)
I have a very long list of addresses, and the city/state/zip are in ONE cell (which is ok) but they're falling under different columns all over the place.
Is there a quick way to shift the cells to the right so at least the city/state/zip is all in the same column?
I'm not sure of the best way to handle this. I was thinking of maybe offsetting each row by the number of blank cells in the "Address" columns, but that would require vba I think.
If there's an easier way I'd appreciate a tip. :)