Below is a Regular Expression to replace alphabets and spaces.
If you need numbers too then modify the expression.
Note that there is a space before the closing bracket.
[A-Za-z ]
Output after replacement
Below is a Regular Expression to replace alphabets and spaces.
If you need numbers too then modify the expression.
Note that there is a space before the closing bracket.
[A-Za-z ]
Output after replacement
removed
- Read your excel row by row
- For the first row use the Replace text as suggested above and then write the result back to Excel
- For second row read the text and use the python script as here and then write the replaced value back to Excel.
removed