How to separate the cell contents in Microsoft Excel

Microsoft Excel Tips

One day I get questions from my friend, he said “Can I take a some part of word in cell Excel?

For example you have data BP001 and you want to take some part of the expression such as "BP” or" 001 " only
Can we do this in excel?

In the example below, I will separate the words www.gokhiel.com , and I want to take some part of sentence : www, gokhiel and .com only.
Please see the formula and the result from the table below:



To separate the cell contents, we can use the LEFT and RIGHT fnction.
LEFT function will cut and count the sentence from the left.
RIGHT function will cut and count the sentence from the right.

Related Topics:
How to Hide and Protect Pattern / Formula in Microsoft Excel 2007
How to Change Upper and Lower Text in Excel
How to Repair corrupted files in Microsoft Excel 2007
How to Paste your data from Notepad to the Excel Columns
How to change Text color in the cell that contains negative numbers in Excel 2007
How to separate the cell contents in Microsoft Excel
Microsoft Excel 2007: How to take limit value to the cell