how to separation letter and numeral

º

º¼ÖÝÈË

separation Letter and numeral
If A1= asd123dsa, how to get the B1= asddsa, C1=123
 
B

Bob Phillips

See previous post in .worksheetfunctions

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top