Conditional Removal Of Text from Cell Value

[bdb1974]

Hi all,

This is an continuation to some earlier formulations to place value correctly in cells.

It started for me here:
http://www.excelforum.com/excel-gene...ell-value.html

Now, I've come across another situaton.

If there is a value of any combination of numerals and text "X" specifically as: 1x,21x,100x,1001x,10230x, I'd like to have the x removed.

The resultant will be in column D of sheet FormulaOut.

Please see attachment as this will be building on the following formula:

Please Login or Register  to view this content.

thanks,

bdb

[NBVC]

How about, in E10?

Please Login or Register  to view this content.

copied down.

[bdb1974]

The formula works, but now, if I copy the formula down a row
and it comes across 100ft or 6' it will not remove the metric symbol.

Thanks,

bdb

[NBVC]

You sample didn't lead me to believe there were those alternatives.. and you only mentioned the "X" in your original post...

...anyways, try then:

Please Login or Register  to view this content.

[bdb1974]

NBVC Excellant!!!

Thanks,

bdb