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

Source: Internet
Author: User

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.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.