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