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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.