Extract Part of Text String

This post will guide you how to extract part of text string from a cell in Excel. How do I extract a word from a text string in Excel. How to extract a substring from a text string in a Cell in Excel. How to extract a substring from the most left of a text string in Excel. How to extract a word from the most right of a text string in Excel.

Assuming that you have a list of data in the range of cells B1:B5, and you want to get the most left 5 characters from cells, or you want to get the most right 4 characters as a substring from cells, how to achieve it. Let’s see the below detailed steps.

Extract Word from the Left of a String


To extract word from the left of a text string in a cell in Excel, you can create a formula based on the LEFT function. Like this:

=LEFT(B1,5)

Type this formula into a blank cell, then press Enter key in your keyboard. And drag the AutoFill Handle over to other cells to apply this formula.

Let’s see the result:

extract part of text string1

You will see that all the most left 5 characters have been extracted into the range C1:C5.

Extract Word from the right of a String


If you want to extract a substring from the right of a text string in a cell, you can use a formula based on the RIGHT function. Like this:

=RIGHT(B1,4)

Type this formula in a blank cell, Press Enter key to apply this formula. Then drag the AutoFill handle over other cells.

extract part of text string2

Extract Word from the Mid of a String


If you want to extract a substring from the mid of a text string in a cell, you can use a formula based on the MID function. Like this:

=MID(B1,6,3)

This formula will extract a substring from a text string in Cell B1, and the starting position is 6, and the length of substring is 3.

extract part of text string3

Related Functions


  • Excel LEFT function
    The Excel LEFT function returns a substring (a specified number of the characters) from a text string, starting from the leftmost character.The LEFT function is a build-in function in Microsoft Excel and it is categorized as a Text Function.The syntax of the LEFT function is as below:= LEFT(text,[num_chars])…t)…
  • Excel RIGHT function
    The Excel RIGHT function returns a substring (a specified number of the characters) from a text string, starting from the rightmost character.The syntax of the RIGHT function is as below:= RIGHT (text,[num_chars])…
  • Excel MID function
    The Excel MID function returns a substring from a text string at the position that you specify.The syntax of the MID function is as below:= MID (text, start_num, num_chars)…

Comments

So empty here ... leave a comment!

Leave a Reply

Your email address will not be published. Required fields are marked *

Sidebar