If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
split the content of cell
how do we split the content of one cell into two cells
example : 6'X3' = 6 and 3 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
split the content of cell
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 |
Thread Tools | |
Display Modes | |
|
|