Hello
An easy way is to just press control F then click the replace tab enter
what you want removing in the "find what field", leave the "replace
with" field blank & then click replace all.
This will remove all of what was selected, however it will leave gaps
in you list this can either be sorted or you could write some
Vb to
remove the gaps.
Hope this helps
--
robmeister
------------------------------------------------------------------------
robmeister's Profile:
http://www.excelforum.com/member.php...o&userid=24364
View this thread:
http://www.excelforum.com/showthread...hreadid=380208