Hello all,
In my excel worksheet, I have a column that contains text and I need to split the text input into multiple columns such as Name, Address, Postcode and Town.
Unfortunately, the name and address and town part of the text string are uneven and only the post code has a unique format i.e. only 5 numbers, I would like to be split the text string into different columns, as shown in the excel attached.
Does anyone know how to achieve this?
Kind regards
Bookmarks