Try to add more spaces into text cell (i.e : 7) to get unique text with at least 7 spaces:
=LEFT(A1,FIND("@@",SUBSTITUTE(A1&REPT(" ",7)," ","@@",7),1)-1)
Try to add more spaces into text cell (i.e : 7) to get unique text with at least 7 spaces:
=LEFT(A1,FIND("@@",SUBSTITUTE(A1&REPT(" ",7)," ","@@",7),1)-1)
Quang PT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks