For example, =RIGHT(“apple”,3) returns “ple”.
TEXT Function
The Excel TEXT function returns a number formatted as text.
in a text string with the number format of your choice.
Increment a number in a text string
This formula looks at one way to increment a number that is embedded in a text string. The purpose of this example to show how multiple functions can be combined to split, manipulate, and rejoin values. In the example shown, the formula in D5 is: ="Item "&TEXT(RIGHT(B5,3)+C5,"000") This formula increments the number in column B by the value in column C, and outputs a string in the original format.
