I want to split containt of a cell and copy in seprate cells
 

I want to split containt of a cell ( combination of text, date, number with
space between them) and copy in seprate cells. exactly a function that run
reverce of Concatination
Thanks
Sima

In cell one use
=left(A1,N)
where N is the number of characters you want in the first cell
in Cell two use
=right(A1,Len(A1)-N)
this will work in N is constant for each cell you want to split
If N is not constant and there is particular character you want to split at
Say ":"
use
=left(A1,find(":",A1)-1)
and
=right(A1,len(A1)-find(":",A1))
"Sima" wrote:

I want to split containt of a cell ( combination of text, date, number with
space between them) and copy in seprate cells. exactly a function that run
reverce of Concatination
Thanks
Sima

Make sure you have empty columns to the right then use datatext to columns
and space as delimiter


Regards,

Peo Sjoblom

"Sima" wrote:

I want to split containt of a cell ( combination of text, date, number with
space between them) and copy in seprate cells. exactly a function that run
reverce of Concatination
Thanks
Sima