Software Delete text before or after character by formula in Excel

Delete text before or after character by formula in Excel

| Written by some jerk | Print | Email | Hits: 279

In Excel, you can use formula to delete before or after a specific character.

Select a blank cell and type this formula =RIGHT(A1,LEN(A1)-FIND(",",A1)) into it, and press Enter button, then drag this formula to fill the range you want. And the all the text before comma are removed in the new range. See screenshot:

doc-remove-before-character-4

Note:

1. Remove the text after comma by using =LEFT(A1,FIND(",",A1)-1).

2. In the formulas, A1 is the cell you want to remove text, and "," is the character you want to remove text before or after it.

3. =RIGHT(A1,LEN(A1)-FIND(",",A1))will remove all text before the first comma in Cell A1, while=LEFT(A1,FIND(",",A1)-1) will remove all text after the first comma in Cell A1.