'Excel formula to remove unwanted character
How to remove unwanted characters on the most right that the back of the word that contain number (from left side) to the right side using Excel formula?
I have tried using Left(cellA, Len(cellA)-7). It works fine to fulfill my needs but it also remove some character when the sentence does not contain unwanted.
If using the Find and Replace method will take much time to check line by line and copy to do.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|