Excel

Hello Rebecca,
I hope you enjoyed your Access training session with us.

This is a very good question, and one that has me pondering what to do. You seem to have tried all the things I would have done as well. The only thing I can think of would be to do a find/replace on

<space>London*

(assuming the addresses are all in London - otherwise, you may need to run this multiple times). This will give you only the street address. Perhaps now the text to columns will be easier to cope with. Once you have all the streets in one column you can concatenate just the street name with "street/road/etc".

I hope this resolves your question. If it has, please mark this question as resolved. If you require further assistance, please reply to this post. And please feel free to ask any other questions you may have.

Have a great day.

Regards,
Mara
Microsoft Office Specialist Master Trainer