Delete Repeating text in cells
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
|