Extracting Text

  • Thread starter Thread starter Shaz
  • Start date Start date
S

Shaz

Hello
I have a list of cells and in each cell there is a sentence of varying
lenght that I want extracted. The one thing common to each cell is
that the final word of the sentences starts SEL_*** (*** represents
different numbers). I have tried Text To Columns using the underscore
but of course I need to also delete/remove the SEL. Is there a
solution as I don't wish to go through all of the list manually.
Many thanks.

Shaz
 
Hi Frank
Looks a bit like this:
A1 This is a test SEL_1234
A2 Feed the animals SEL_1235
Etc

Hope this helps.
TIA
Shaz
 
Back
Top