eliminate partial content from the cell
 

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

eliminate partial content from the cell
 

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

"viktor" wrote in message
...
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

eliminate partial content from the cell
 

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

"Anne Troy" wrote:

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

"viktor" wrote in message
...
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

eliminate partial content from the cell
 

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

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

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

"Anne Troy" wrote:

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

"viktor" wrote in message
...
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