Hi Max

Many thanks for the tip.

Unfortunately it doesn't do what I require.

I need it to work over a selection of at least 30 groups and so the
phrase to be automatically deleted from the original list.

Do you have any ideas, another formula or macro.


--
exiled
------------------------------------------------------------------------
exiled's Profile: http://www.excelforum.com/member.php...o&userid=35619
View this thread: http://www.excelforum.com/showthread...hreadid=553972