Monday, October 12, 2009

Oracle substr() equivalent function in Excel

For converting 911120202020 into 20202020

please use the excel function

=MID(A1,SEARCH("9111",A1)+4,8)
Posted by at
Labels: , , , ,
Subscribe to: Post Comments (Atom)