how do we split the content of one cell into two cells
example :

6'X3' = 6 and 3

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

Try

=--SUBSTITUTE(LEFT(A1,SEARCH("X",A1)-1),"'",)

=--SUBSTITUTE(MID(A1,SEARCH("X",A1)+1,10),"'",)


--
Jacob (MVP - Excel)


"cosmic" wrote:

how do we split the content of one cell into two cells
example :

6'X3' = 6 and 3

are all the cells looks with above mentioned format? can you give with more examples. we can define right formulae based on examples.

all the best