Hello,
I was wondering if someone could help me. I need a formula to extract numbers. The problem is that what I need are loan numbers and some numbers within the cell is not part of the loan number. For instance:
DATA (Column A)
B012.T01234TOPSHEET
.1234567890T22222ADM
B1235678901234T22222
RESULT (Column B)
BLANK (No Loan Number to extract)
1234567890
5678901234
Is there a formula than can do this for me?
The amount of data changes every month. Sometimes there is one day of activity and sometimes there are 5 to 10 days worth of activity. I need to do the same formula for multiple spreadsheet and would also like to know if I can create a macro for this as well.
Thank you!
~MHamid
Bookmarks