Addresses problem

[rbacon100]

Hi all. Is there any way for me to do this?

I have cells looking like this

WHITWORTH CLOSE WELLESBOURNE WARWICK STRATFORD-ON-AVON WARWICKSHIRE A

and it needs to look like this

Whitworth Close Wellesbourne, Warwick CV35 9NQ, UK

Now. I found out that when you write
WHITWORTH CLOSE WELLESBOURNE WARWICK STRATFORD-ON-AVON WARWICKSHIRE A into google it will show you correct address.

Is there any way to do this quickly? Because I have around 60k of data like this.

THank you

 

[rbacon100]

actually, I may have another solution. It will be slower but it can work.

I can make geo codes from that "bad" addresses but I need to convert them back to addresses. Now I found online how to conver codes to addresses but all was for 1 geo code.

Is there any way to convert list of geo codes to addresses?