Splitting textstring (adress) into seperate columns

Maybe:

Please Login or Register  to view this content.

Try the attached

Originally Posted by jindon

Try the attached

Works fantastic!!

But how to implement if you have data in other cells?

Addresses are actually in column "F" and I have data in cells from column A to S.

I tried to insert two extra columns after "F" and had the first address selected then run your code, no success...

How can I make it work from the "F" column?

Thanks for fast reply!

Data in Col.F, output to G:I ?
change to

Please Login or Register  to view this content.

Great!

Thanks!