Sunday, April 24, 2011
How to separate two words within a single cell to be divided in two cell in Ms Excel
Do you like this story?
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))
• For the second new cell =MID(A1,SEARCH(" ",A1)+1,30)
• Just copy & paste for the next row.
• To Copy those new cells into the new sheet or new file, use the paste value only.
in Dept Reviews
Graphic designer, web designer and business man with really strong passion that specializes in marketing strategy.
Subscribe to:
Post Comments (Atom)
0 Responses to “How to separate two words within a single cell to be divided in two cell in Ms Excel”
Post a Comment