Hi Don

Try Find & Replace
Press Ctrl + H
Find Company: (do type a space after the colon)
Replace (leave totally blank)
Replace All

--
Regards

Roger Govier


"Don B" <Don wrote in message
...
How do you delecte repeating text in cells? For example, a list of
companies
that includes Company: xxxxx in every cell. All I want is the name.
I am
using Excel 2003.