Microsoft Office Forums - View Single Post - How to extract only numbers from a STRING?

Thread: How to extract only numbers from a STRING?

View Single Post

Old

04-19-2011, 02:43 AM

Colin Legg Colin Legg is offline

Colin Legg is offline

Colin Legg uses Windows 7 32bit

Windows 7 32bit Colin Legg uses Office 2010 32bit

Colin Legg uses Office 2010 32bit

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

Colin Legg will become famous soon enough

Default

Hi,

If you can assume that the number will always come at the end, this formula will do it:

Code:

=TRIM(MID(A1,MIN(SEARCH({1,2,3,4,5,6,7,8,9,0},A1&"1235467890")),255))+0

Reply With Quote