Hi,
I have attached a file with some data that needs splitting, there is no common delimiter.
I managed to get half way there but then get more issues.
Anyone able to help me. I need to get column D split out into new columns titled Address Line 1, Address Line 2, City, County. Then we need to do exactly the same for Column H, however this will also need to merge into column I as some have postcodes already and some are in the delivery address.
Please help me VBA Kenobi!!