eliminate partial content from the cell

[viktor]

hello,

I want to remove from one column with 700 cells some characters.For example,
in the cell i have: AABB1234567 and i want to eliminate BB; i try with ctrl+h
but i don't have a result.

thank's

 

[Anne Troy]

What do you mean you "don't have a result"? What DOES happen?
************
Anne Troy
VBA Project Manager
www.OfficeArticles.com

 

[viktor]

in "ctrl+h" command i say to replace BB, but the Excel give me a
message:"it's nothing to replace"

 

[Anne Troy]

Make sure "find entire cells" or "match entire cell contents" (under
Options) isn't checked.

************
Anne Troy
VBA Project Manager
www.OfficeArticles.com