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.