Hi all
I need to seperate text in a column into different columns.
Text to columns doesn't work because it seperates all the text.
In this column, I need the text that has more than three spaces between it to be moved.
Eg.
A1= Flat 1 Sky Way Scotland SW1
A2= 23 Dock Road Docklands DK3
A3= 161 Speed Drive Gasville GV7
Between the first set of text and the second, there is a minimum of 3 spaces. I desperately need the second lot in the second column.
The Postcode is two spaces after the town's name which must not be affected, but rather move with the town's name.
Please help if you can..!!
Many thanks
Joey
Bookmarks