Try:
![]()
=TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",255)),SEARCH({1,2,3,4,5,6,7,8,9,0},SUBSTITUTE(A1," ",REPT(" ",255)))-255,500))
Try:
![]()
=TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",255)),SEARCH({1,2,3,4,5,6,7,8,9,0},SUBSTITUTE(A1," ",REPT(" ",255)))-255,500))
Quang PT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks