Extracting words from string based on certain characters...?

[Flabbergaster]

Hi

I'm preparing a lot of text i a worksheet for analyzing puporses.

The thing is, som words occur several times, but in different spelling due to automatically generated hyphenation in the source text.

That is,

The word, say "awesome", occurs both as "awesome", "aw-esome", "awe-some" etc.

What I want do be able to do is to extract all the words with an hyphen in it. an put the in a new column. Btw there are often more than one word in each cell containing a hyphen.

It's not an option to use find/replace, while in some cases the hyphen is supposed to be there.

Thanks
Jacob

[Pepe Le Mokko]

Why not copy the entire range to another column and, using the filter, filter all words " not containing" a hyphen, then delete them?

[Flabbergaster]

Oh.... I haven't given that a thought - at all.... Thank you.