
Example #6īelow are the errors find out while you are working on the web-based software. Part 3: FIND function determines from which number “ begins. Part 2: LEN function will give you the total number of characters in the list.

That means LEN – FIND (16 – 5) = 11 characters from the right side. Len gives 16 characters, and find gives 5 characters for the first employee. That means LEN – FIND (10 – 5) = 5 character from the right side. Len gives 10 characters, and find gives 5 characters for the first employee. We will see the detailed article on FIND in the upcoming articles. Part 3: The FIND function determines from which number space begins, i.e. We will see the detailed article on LEN in the upcoming articles. Part 1: This part determines the desired text that you want to extract the characters. Here we need to use LEN & FIND function to determine the number of characters from the given text. Robort Adam), and for the third one, it is 12 (including space, i.e.

For the first employee last 4 characters are 5, but for the second on it is 11 (including space, i.e. In the above example, we cannot just apply RIGHT with specified numbers because the last name of every employee is different. We can extract the last 4 digits of the above text by using the RIGHT function in Excel.Īssume you have serial numbers from A1 to A10, and you need to extract 6 characters from the right.Ī RIGHT function will return the last 6 digits from the right end of the text.īelow are the names of the employees, and you need to extract the Last Name separately.
