Eliminating Alpha Characters

[Steve Morris]

I am trying to eliminate all alpha characters from cells and have tried using "right", "left" and "mid" text formulas. The problem is that there is no pattern to data. The number may be at the front or the back of the cell and may have a different set of spaces between them. Additionally, I want any cell with alpha only to show as blank.

 

[Luke M]

I found a solution in this thread:
http://forum.chandoo.org/threads/removing-all-charcters-from-cell-but-numbers.13352/

Put it in your workbook, tweaked the formatting, and we're good. Just don't ask me to explain how the formula works.

 

[Steve Morris]

Thanks...you da ninja!