How remove the unwanted letters in a column.

[Anonymous]

Hello, 

How can I remove the unwanted letters in the category column below?
I want to remove the PV from each row. 
Thanks!

[Whitewater100]

Here is Power Query fix:

[Whitewater100 · 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!

[Anonymous]

HEY @Whitewater100  Thanks! It was really helpful. 

[Whitewater100]

Great! Thank you..