Hello,
How can I remove the unwanted letters in the category column below?
I want to remove the PV from each row.
Thanks!
Solved! Go to Solution.
Hi:
You can do this a couple of ways I know. Here is a calc column:
You can also do in Power Query with ADDCOLUNM > Column by examples and type in first two and computer will catch on and fix all of them.
Hope this helps!
Here is Power Query fix:
Hi:
You can do this a couple of ways I know. Here is a calc column:
You can also do in Power Query with ADDCOLUNM > Column by examples and type in first two and computer will catch on and fix all of them.
Hope this helps!
Great! Thank you..
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!