I have an excel spreadsheet with 300 addresses that are separated by commas in one column. An example is:
3405 4TH AVE SOUTH, BIRMINGHAM, AL, 35222-2300
I would like to copy and paste the different elements of the address in separate columns (without retyping them all!)
I recollect something called comma separated delimiters but can't figure out how to implement it.
Any help would be greatly appreaciated.
Thank you,
Dave
Bookmarks