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