To separate the two words within a single cell in Microsoft Excel to be divided into two cells, means each word occupies one cell, it's not difficult. using this formula.
For example we have the data below
To separate it into two cells, the formula is :
• For the first new cell
=MID(A1,1,SEARCH(" ",A1)) Read more »