Well, filtering won't work, cause I want to just extract the data into
another sheet.

And the problem with the MID is that the parts I want to extract vary in
their distances from the beginning/end of the string.

"Mich modulus 11" wrote:
many ways to skin a cat, I would try using filtering in your source
worksheet, then go for custom filter for items beginning with xxxx as one
way round it.

You could also split up your cells using MID function in an adjacent column
to bring back the bit you want if the item you want always starts at a set
number of characters from the start / end.



Thanks in advance.