Announcements
removed
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
- 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.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
David_MA 246 Super User 2026 Season 1
11manish 176
Haque 157