There are several ways to approach this problem.
In the current version of Excel, the easiest solution is to use the TEXTAFTER function.
Both approaches are explained below.
TEXTAFTER extracts text that occursaftera given delimiter.
If the space character is not consistent (i.e.
TEXTAFTER has many other options that you’re able to read .
This formula achieves the same result but in a more manual way.
Note: If there is no space after the comma, there is no need to subtract 1.
For example, =RIGHT(“apple”,3) returns “ple”.
LEN will also count characters in numbers, but number formatting is not included.
When the text is not found, FIND returns a #VALUE error.
