Reputation: 63
I have this data in column
now i want to extract last numbers and put into another column ..
how i do this
Upvotes: 0
Views: 311
Reputation: 8240
Results:
Upvotes: 0
Reputation: 6982
Extract just numbers from a string
=MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),99)*1
Upvotes: 2