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.

Select the range and
Edit|Replace
what: Company:__ (where __ is 2 space characters)
with: (Leave blank)
replace all


Don B wrote:

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.

--

Dave Peterson

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.