|
04-19-2011, 03:32 AM
|
|
Advanced Beginner
|
|
Join Date: May 2010
Posts: 51
|
|
Quote:
Originally Posted by Colin Legg
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
|
Thanks a lot for your kind help. It is working fine.
Regards.
|