I need some help with Exel Please
I have a sheet with 2 Columns 1, has Names 2, Has address

Column 2 is the problem it has address like so :- anystreet anytown anycounty anypostcode

what I was asking for your help with is there a way of moving the text ie anytown to a new column

other way i can explain is find text anytown and move to column 3

I have thought about cut and paste but there are over 3000 address to move

You help would be greatly appreciated
Thank you