Looking for a formula to extract data from a cell

To extract all the data from the right side of a separator in a cell, you could combine Right, Find and Len functions together.

1.The Len function automatically calculates the length of a string within a cell. The result of "Len(B3)" is 10, indicating that the total length of characters in cell B3 is 10.

2.The Find function determines at which position a character first appears within a cell. The result of "Find("·",B3)" is 5, indicating that the separator appears for the first time at the fifth position within cell B3.

3.By subtracting these two functions, the result of "=Len(B3)−Find("·",B3)" is 5.

4.The Right function is used to retrieve a specific number of characters from the right side of a cell.

5.Therefore, "=RIGHT(B3,LEN(B3)−FIND("·",B3))" means to retrieve a string of 5 characters from the right side of cell B3. With this formula, Excel can automatically retrieve characters from the right side of a cell until it encounters the separator.

The correct formula for you could be "=RIGHT(B3,LEN(B3)−FIND("·",B3))"

B3 could be replaced with any cells that you need to extract data from. Hope this can help you.

Newer versions of Numbers have the TEXTAFTER function to make this easier.

=TEXTTAFTER(A3,"- ")