I have an 8000 row sheet, in one column there are variations like"
AC
A1
2C
AC1
A2B
The only info I need is the numeral, which appears in many possible locations in the string. How do I get just the numeral out into a new column? Also if there is no numeral I want a blank cell
perhaps..
=IFERROR(LOOKUP(99^99,--("0"&MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),ROW($1:$10000)))),"")
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks