Solved: How remove the unwanted letters in a column.

Anonymous · ‎04-07-2022

Hello,

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

Whitewater100 · ‎04-07-2022

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!

Whitewater100 · ‎04-07-2022

Here is Power Query fix:

Whitewater100 · ‎04-07-2022

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 · ‎04-13-2022

HEY @Whitewater100 Thanks! It was really helpful.

Whitewater100 · ‎04-13-2022

Great! Thank you..

How remove the unwanted letters in a column.