Replacing specific text within a table cell

[Barb Reinhardt]

I have identified a specific textrange that I want to replace text in, but am
not sure how to go about doing it. I want to change "M" to "" and "$" to ""
in that text range. Can someone assist?

Thanks,
Barb Reinhardt

 

[John Wilson]

Hi Barb

Is this "M" and" $" as discreet words or within other words. Surely
replacing all M's with "" would give some unexpected results?

 

[Barb Reinhardt]

It's with specifically identified cells and is not a global change. I've
actually determine how to do this, but the results are now strings and I need
them to be numeric. How can I resolve this?

Thanks,
Barb Reinhardt

 

[John Wilson]

Use CLng to convert to a long number
not very good example!
strsA ="2"
A =CLng(strsa)

 

[John Wilson]

Maybe I misunderstood? "M" as a number?? Did you mean the character code?

 

[Barb Reinhardt]

That's exactly what I'm doing. Let me check this out.