Stripping characters from cells

[Timbo50]

Hi, I have a column of cells with numbers and text. I would like to strip the numbers out, but there is a character at the front and one at the end of the cell content e.g. (*123.4p and *12.4506p) The additional problem is that the cells have different length of numbers. Any help would be appreciated, preferably with formula. Thanks.

 

[jtakw]

Hi,

Please be a little more specific, which are the characters you want extracted?
The ones represented as * or the p(s) in your sample?

 

[PatOBrien198]

Or, if you are wanting to keep the numbers:

=VALUE(MID(G9,2,LEN(G9)-2))

where the *12.34p is in cell G9

 

[Timbo50]

Hi jtakw,

thanks for responding. I'm looking to extract the numbers, so I've got to get rid of both the '*' and the 'p's.

 

[Timbo50]

Hi Pat,

Many thanks. That works perfectly.