ExcelBanter - split the content of cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - split the content of cell (https://www.excelbanter.com/excel-worksheet-functions/264770-split-content-cell.html)

Cosmic

split the content of cell

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

6'X3' = 6 and 3

Stefi

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

Jacob Skaria

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

bala_vb

Quote:

Originally Posted by cosmic (Post 956700)

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

All times are GMT +1. The time now is 12:38 PM.