Prev: Get Google adsense account approval in 4 hours
Next: Reposition comment boxes in 2000
From: cosmic on 28 May 2010 02:58
how do we split the content of one cell into two cells
example :

6'X3' = 6 and 3

From: Stefi on 28 May 2010 04:26
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
>
From: Jacob Skaria on 28 May 2010 05:16
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
>
 | 
Pages: 1
Prev: Get Google adsense account approval in 4 hours
Next: Reposition comment boxes in 2000