How to Extract a Substring in Microsoft Excel

Extract a Substring in Microsoft Excel

In this article, we will tell you how to extract a substring in Microsoft Excel. So, without further ado, let’s get started!!

Microsoft Excel is the most widely used app for data calculation and statistical basis. It let you format, organize and calculate data in a spreadsheet. You can make a flow chart, tables, and graphs to prove your results regarding maths, stats, econometrics, and so on. You can extract a substring from the left, right, or middle of your text, you can use Microsoft Excel’s LEFT, RIGHT, MID, LEN, and FIND functions. It also contains a large number of boxes called cells that are ordered in rows and columns.

Extract a Substring in Microsoft Excel

Extract a String To the Left of Your Text

If you want to the left of the specified character in your cell, follow the simple steps given below:

  1. Open your spreadsheet and click the cell in which you want to see the result
  2. Now, type the following function in the selected cell and replace B2 with the cell where your full text is and @ with the search character then, press Enter:

=LEFT(B2,FIND(“@”,B2)-1)

However, your selected cell displays the result of the function, which is the full text before your specified character in your cell.

Extract a String to the Right of Your Text

If you want to the right of the specified character in your cell, follow the simple steps given below:

  1. Open your spreadsheet and click the cell in which you want to see the result
  2. Now, type the following function in the selected cell and replace B2 with the cell where your full text is and @ with the search character then, press Enter:

=RIGHT(B2,LEN(B2)-FIND(“@”,B2))

However, you will see the result of the function in the selected cell.

Extract a String From the Middle of Your Text

If you want to the middle of the specified character in your cell, follow the simple steps given below:

  1. Open your spreadsheet and click the cell in which you want to see the result
  2. Now, type the following function in the selected cell and replace B2 with the cell where you have the full text, 1 with the position of the character where you want to start the string selection, and 3 with the number of characters you want to extract. Then, press Enter:

=MID(B2,1,3)

However, it will extract the specified number of characters from the given position in your cell.

Also see: How to Change the Alarm Volume on iPhone

That’s it, guys!! The above-mentioned details will surely help you to extract a substring in Excel. Try these steps out and interpret your characters as per your choice. Well, we hope that you liked our article How to Extract a Substring in Microsoft Excel. For any queries, do let us know and also, share your reviews in the comment box mentioned below. 

Posted by
TechChalks

Admin at Tech Chalks, Love To Share My Experiences With the World of Tech Geeks.

Leave a Reply

Your email address will not be published.