Hi All,
I am trying to separate into cols address details that have been placed into one excel cell.
I have attempted using the Left(cell no(Find function) which brings back everything before the first comma, but I have no idea now how to bring back the others. The postcode works for some address lines but not others - think this is due to the number of characters in the cell...)
Can anybody please help?
Many thanks
Suzanne
Bookmarks