Got lots of cells in one column, I want to delete the same repeated text string from all the cells, they all say ‘repeated text- something ‘ and I want them all to end up as ‘something’. Thanks in advance.

Find and replace (CTRL + H and choose the replace option)

Put the text string in the find box, leave the replace box blank, choose replace All. Job Jobbed.

Ctrl + H
Find: Repeated Text
Replace:

find and replace (ctrl H) repeated text with nothing?

Select column, ctrl-H, find: “repeated text-“, replace: “”.

[Waaay too slow… 😀 ]

Ah, looks like we all agree

And hello chum3, long time no see!

All you have to do now is figure out who I am!

Just to mix it up a little you could:

Data > Text to columns > Delimited > select/type your delimiter “-” > finish

and then delete the columns you don’t want

For the love of Baby Robins… Its Friday – stop it please.

and don’t forget the ‘undo’ button for when you’ve cocked it up.

For the love of Baby Robins… Its Friday – stop it please.

Clearly austerity measures are kicking in if people have to work on a Friday 🙂

Ah, that was too easy.

It doesn’t have to be so easy….

If column A contains the data repeated text-something

Then for column B put
=RIGHT(A1,LEN(A1)-LEN(“repeated text-“))