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

[Guest]

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

 

[Guest]

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))

 

[Guest]

Make sure you have empty columns to the right then use data>text to columns
and space as delimiter


Regards,

Peo Sjoblom