Dear all,

I want to get only number from cells in Excel, for example, "$123m/di" in a
cell, I want "123" left. I tried Value function in Excel, it doesn't work.

I remeber I'v seen a article before, which mentioned how to extract number
or text from cells in Excel. But I forgot how to do it totally. Or can I do
it in some function?

Thanks.
JIANG