Moving Text in Exel

Originally Posted by Tuggy

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

it is better to use Text to columns feature of Excel
copy the data to new sheet before you try this
then select the column of data
go to Data > Text to Columns and select Delimited (next) > check space option only (next) and finish.
you can now copy the 2nd column which only contains anytown to your desired column.

You instructions worked out great
Thanks very much for the help starguy

Originally Posted by Tuggy

You instructions worked out great
Thanks very much for the help starguy

you're welcome.
thank you for the feedback.