Try the following array formula (to be entered using Ctrl+Shift+Enter, not just Enter):
=TRIM(REPLACE(A2,MAX(IFERROR(FIND({0,1,2,3,4,5,6,7,8,9},A2,ROW(INDIRECT("1:"&LEN(A2)))),0))+1,0," "))
Try the following array formula (to be entered using Ctrl+Shift+Enter, not just Enter):
=TRIM(REPLACE(A2,MAX(IFERROR(FIND({0,1,2,3,4,5,6,7,8,9},A2,ROW(INDIRECT("1:"&LEN(A2)))),0))+1,0," "))
That's perfect--thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks