Delete Repeating text in cells

[Don B]

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]

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

 

[Roger Govier]

Hi Don

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