Split Text in One Cell into Two

Spread the love

If you want to split text in one cell of a Microsoft Excel sheet into multiple cells, you can do it with an excel formula.
For example, if cell A2 contains the First Name and Last name of a person and you want the First Name in Cell B2 and Last Name in cell C2, it very easy.
Put your curser in cell B2 and put this formula
=LEFT(A2,FIND(" ",A2,1)-1)
Now put you curser in cell C2 and use this formula
=RIGHT(A2,LEN(A2)-FIND(" ",A2,1)).

You might also like