< Go Back

Remove characters from right

If you have a set of data written in excel sheet which is containing both numerical data as well as characters and you want to extract only the numerical data from the sheet which is done when removing characters from right, then this article will help you. The function that can be used to extract numerical data is known as the LEFT and LEN function. This function is applicable to any data having both numerical data as well as characters.

SYNTAX

The general formula for extracting numerical data is as follows:

= LEFT (text, LEN (text) – n)

EXPLANATION

This formula can be used to remove characters from the right of the data. In the figure below, we can see that there are six characters with each of the data in column C. SO the formula will include 6 as n so that all the six characters are removed. Once the characters are removed from the data, this results in the extraction of only numerical data in Column D as shown in the figure below:

The formula that was used to extract data in the figure below is as follows:

=VALUE(LEFT(C3,LEN(C3)-6))

Figure.1: Removing characters from right

Working:

The formula working is simple, you just have to enter the number of characters that you want to be removed from the data which indicates “n”. Once you enter the exact number of characters in the formula, it removes the characters and only numerical data is left which is the desired result. The formula is applicable in many cases when the result is desired in the form of numerical data. For any reports that do not need numerical data, the LEFT and LEN function is not applicable.

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment

avatar