Excel Guides

Dissecting a String in Excel

There are a few different ways that you can dissect a string in Excel. One way is to use the LEFT, RIGHT, and MID functions. Another way is to use the FIND and SUBSTITUTE functions. And yet another way is to use the REPLACE function. Let's take a look at each of these methods in more detail.

Using the LEFT, RIGHT, and MID Functions

The LEFT, RIGHT, and MID functions are very similar. The only difference is that the LEFT function starts from the left side of the string, the RIGHT

.

.

.

How to Use LEFT, RIGHT, or MID in Excel: Formula Examples

.
  1. Extract First or Last Characters from a String in Excel

  2. Get Middle Characters from a String in Excel (MID Function)

  3. Combine LEFT and RIGHT Functions in Excel (or MID)

.

Using FIND and SUBSTITUTE to Dissect Strings in Excel

.
  1. Find Text Position within a String in Excel (FIND Function)

  2. Replace Part of a String with Another (SUBSTITUTE Function)

.

Replacing Text with REPLACE Function in Excel

.
  1. Method 1.: Replace text by position using REPLACE function.
  2. >
    • Example 1.: Replace 2nd word with another text.
    • >
      • Formula = : =REPLACE(A1,FIND(" ",A1)+1,FIND(" ",A1,FIND(" ",A1)+1)-FIND(" ",A1)-1,"New")).
      • >Result = "I want to replace this text." " " " " " " " " " " "<!--[if !supportLineBreakNewLine]--> <!--[endif]-->;".
      >.
      >.
      >.
      >.
      >.
      >.
      >.
      >.
      .
    >.
    >.
    >.
    .
.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.