Forum Discussion
Huge cleanup
Hi,
I want to make a huge cleanup in several columns. On day column I want to change characters like "00", "/", "32", "000", etc, into "".
On month, something like what. In year, I need to change characters like where year > 2000 to "".
Is it posible to make something like this? I can see I can make one by one, without the formula.
Thank you
Edgard
- Anonymous9 years ago
Hi efilipe,
You can try to use power query to achieve your requirement.
Reference links:
Multi Condition Logic In Power Query
Using List.Generate() To Make Multiple Replacements Of Words In Text In Power Query
Regards,
Xiaoxin Sheng
1 Reply
- AnonymousNot applicable
Hi efilipe,
You can try to use power query to achieve your requirement.
Reference links:
Multi Condition Logic In Power Query
Using List.Generate() To Make Multiple Replacements Of Words In Text In Power Query
Regards,
Xiaoxin Sheng