Excel intercepts the left and right characters with a colon as a reference breakpoint

This tutorial is about how you can intercept a string on both sides of a colon, but not a colon.

Let's look at the table below.

In the table above, the string in column A, which has a colon in a different place, now, what we're going to do is to intercept the character on the left of each cell and the character on the right.

The method is simple, you can use a function, but you need to understand how these functions are used.

One, intercept the character to the left of the colon

The following figure, the formula uses: =left (A2,find (":", a2,1)-1) can be.

Second, intercept the character to the right of the colon

The following figure uses the formula: =right (A2,len (A2)-find (":", a2,1)).

Computer Tutorials

Iii. Description of the formula

The left formula is a function that intercepts characters from the left-hand side;

Right is the function that intercepts characters from the right-hand side;

And find function is lookup function, this tutorial looks for the location of the colon, with the location of the colon as a reference, respectively, intercept the left and right characters.