Power Query, Replace Text not working for specific text|Power Query|Excel Forum|My Online Training Hub

Hi,

My file takes a horrendous report from our accounting system and converts it to a table taking away all useless info.

I have added a conditional column to categorise the accounts, based upon their intial number.

However I do have exception to the rule, one specific account (51626) would be categorised as Payroll in the above step when in fact it is an expense.

When I enter this at the end of the add conditional column step , nothing happens, it is still classed as a payroll account.

So I then tried my plan b to merge the 2 columns (category and acct) to give me the combined text and then asked for a replace text to replace the word Payroll with Expenses on that one combination, I then split the column back again.

again it has not worked.
Could you please advise where I am going wrong?

thanks ever so much
Sharon