C cosmic May 28, 2010 #1 how do we split the content of one cell into two cells example : 6'X3' = 6 and 3
S Stefi May 28, 2010 #2 Left part: =LOOKUP(6.022*10^23,--LEFT(A1,ROW(INDIRECT("1:"&LEN(A1))))) Right part =LOOKUP(6.022*10^23,--RIGHT(SUBSTITUTE(A1,"'",""),ROW(INDIRECT("1:"&LEN(SUBSTITUTE(A1,"'","")))))) -- Regards! Stefi „cosmic†ezt Ãrta:
Left part: =LOOKUP(6.022*10^23,--LEFT(A1,ROW(INDIRECT("1:"&LEN(A1))))) Right part =LOOKUP(6.022*10^23,--RIGHT(SUBSTITUTE(A1,"'",""),ROW(INDIRECT("1:"&LEN(SUBSTITUTE(A1,"'","")))))) -- Regards! Stefi „cosmic†ezt Ãrta:
J Jacob Skaria May 28, 2010 #3 Try =--SUBSTITUTE(LEFT(A1,SEARCH("X",A1)-1),"'",) =--SUBSTITUTE(MID(A1,SEARCH("X",A1)+1,10),"'",)
