Glaswegian
03-15-2007, 05:26 AM
Hi
Not being very good with formulae, I'm a bit stuck and need some help.
I have cells with the following mixture of text and numerals.
ANYTEXTHERE.123456 TEXT
The amount of text before the numerals is variable and the number of numerals is variable. However, there is always a full stop before the numerals and always a space after the numerals. I therefore need to extract only the numerals.
My best shot at this came up with
=MID(A26,FIND(".",A26,1)+1,LEN(A26)-(FIND(" ",A26,5)))
but the problem (I think) is to do with the last FIND part.
Any help greatly appreciated.
Not being very good with formulae, I'm a bit stuck and need some help.
I have cells with the following mixture of text and numerals.
ANYTEXTHERE.123456 TEXT
The amount of text before the numerals is variable and the number of numerals is variable. However, there is always a full stop before the numerals and always a space after the numerals. I therefore need to extract only the numerals.
My best shot at this came up with
=MID(A26,FIND(".",A26,1)+1,LEN(A26)-(FIND(" ",A26,5)))
but the problem (I think) is to do with the last FIND part.
Any help greatly appreciated.