Or alternatively you may also try this......
![]()
=LEFT(REPLACE(A1,1,IF(LEN(A1)-LEN(SUBSTITUTE(A1," ",""))=1,FIND(" ",A1),FIND("*",SUBSTITUTE(A1," ","*",2))),""),1)&" "&LEFT(A1,FIND(" ",A1)-1)
Or alternatively you may also try this......
![]()
=LEFT(REPLACE(A1,1,IF(LEN(A1)-LEN(SUBSTITUTE(A1," ",""))=1,FIND(" ",A1),FIND("*",SUBSTITUTE(A1," ","*",2))),""),1)&" "&LEFT(A1,FIND(" ",A1)-1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks