split the content of cell
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:
how do we split the content of one cell into two cells
example :
6'X3' = 6 and 3
|