Dear Friends,
We have some lengthy rows data, from that we need take out the numbers which is coming after the "Term No", So
Please give your precious Ideas to solve it.
EG:-
"SPAN SETTLEMENT/010319265004 SPAN SETTLEMENT 010319265004 Ref:-TERM NO 55351129 AT 11:57 "
we need the answer :- 55351129
If the number format will always be the same, use this...
=MID(A1,SEARCH("term No",A1,1)+9,8)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks