Forum Discussion
Solved
Modify Value in a Column
Hello, I am having a table that is getting data from csv files from a sharpoint folder. The value is coming as "XXXX, YYYY, North America". Now I want to eliminate the ",North America" part from the...
Hi utsavlexmark
In Power Query (Transform Data) click on the column header then click Replace Values.
In Values to Find enter ,North America and leave Replace With empty.
Click OK
Regards
Phil
Hi utsavlexmark
In Power Query (Transform Data) click on the column header then click Replace Values.
In Values to Find enter ,North America and leave Replace With empty.
Click OK
Regards
Phil