Try this
B1: =LEFT(A1,FIND(" ",A1,LEN(A1)/2))
C1: =SUBSTITUTE(A1,B1,"")
Text in B1 will be slightly longer than C1 because it does the cutoff at the first Space after half of the text..
Try this
B1: =LEFT(A1,FIND(" ",A1,LEN(A1)/2))
C1: =SUBSTITUTE(A1,B1,"")
Text in B1 will be slightly longer than C1 because it does the cutoff at the first Space after half of the text..
Thank bro you are the besT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks