How to separate text form column and get other text onto another column.

[Anonymous]

Hello, 

Here we have a data on the Column "A". we need to eliminate the text "Excess" and paste other data into Column "B".

Thanks..!

Please look at this @Ahmedx. Thanks..!

[Ahmedx]

pls try this

[Anonymous]

Hello @Ahmedx ,

Thanks for your reply. 

Could you please provide the format in the power Query Editor. Because it show some errors with what I type with you gave it.!

Thanks.!

[Ahmedx]

yes, I already wrote how to do this in power query

[Ahmedx · Accepted solution]

and try this in M code

[_AAndrade]

Try this:

IF( SELECTEDVALUE( columnA) = "EXCESS", BLANK(), SELECTEDVALUE( columnA) )

[Anonymous]

Hello _AAndrade, 

Thanks for your reply.

Could you please send it in the query editor format.

Thanks.!