Thread: Split contents of a cell

Hi guys,
I need a wee bit of help please?

What i'm trying to do is split the contents of the cells in column A in to 2 seperate cells.

The contents of the cells in column A are like this:

alpha.bravo.charlie

I want to delete alpha and have bravo as the new contents of column A and charlie as the contents of column C.

Hope I've described that ok.

Thanks in advance

Hi,

Either use these formula

Code:

 
=LEFT(A1,FIND(".",A1)-1)
=MID(A1,FIND(".",A1)+FIND(".",A1,FIND(".",A1))+1,LEN(A1)-FIND(".",A1)+FIND(".",A1,FIND(".",A1)))

or select column A, and go to data > text to columns > delimited > full stop