Hello,
How can I remove the unwanted letters in the category column below?
I want to remove the PV from each row.
Thanks!
1 ACCEPTED SOLUTION
Hi:
You can do this a couple of ways I know. Here is a calc column:
New Cat = REPLACE(Data1[Category],21,2,"")
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!
Hi:
You can do this a couple of ways I know. Here is a calc column:
New Cat = REPLACE(Data1[Category],21,2,"")
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!
