eliminate partial content from the cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

viktor - 17 Nov 2005 13:57 GMT

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

Reply to this Message

Anne Troy - 17 Nov 2005 14:27 GMT

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

> hello,
>
[quoted text clipped - 5 lines]
>
> thank's

Reply to this Message

viktor - 18 Nov 2005 05:36 GMT

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

> What do you mean you "don't have a result"? What DOES happen?
> ************
[quoted text clipped - 11 lines]
> >
> > thank's

Reply to this Message

Anne Troy - 18 Nov 2005 06:23 GMT

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

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

> in "ctrl+h" command i say to replace BB, but the Excel give me a
> message:"it's nothing to replace"
[quoted text clipped - 14 lines]
>> >
>> > thank's

Reply to this Message