Sunday, April 24, 2011

How to separate two words within a single cell to be divided in two cell in Ms Excel

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 :
1. For the first new cell      =MID(A1,1,SEARCH(" ",A1)) 

2. For the second new cell      =MID(A1,SEARCH(" ",A1)+1,30)

3. Just copy & paste for the next row.

• To Copy those new cells into the new sheet or new file, use the paste value only.