 You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
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.
[i]For the love of Baby Robins... Its Friday - stop it please.[/i]
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-"))