View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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