Extracting Text

[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

 

[Frank Kabel]

Hi
could you post some example values and your expected results

 

[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

 

[Frank Kabel]

Hi
try
=SUBSTITUTE(A1,"SEL_","")

 

[Shaz]

Thank you Frank - it worked a treat.

Shaz