Replace

[Anonymous]

Hello Experts,

I have below values in one column, i want to replace CLOSE with CLOSED. Please help me.

[Kishore_KVN]

Hello @Anonymous ,

Follow below steps to achieve it:

1. Go to power query editor (Transform Data)

2. Select this column >>go to transform tab >> click Replace >> Current value will be 'CLOSE' and Replace value will be 'CLOSED'

3. Close and apply the changes. 

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!