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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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))
 
Make sure you have empty columns to the right then use data>text to columns
and space as delimiter


Regards,

Peo Sjoblom
 
Back
Top