Power query text methods

[MichaelF1]

Hi everyone,

How do I apply a text method in M code to a whole column?

I have 

ColumnA	ColumnB
1	abcFred
2	abcJane
3	Markabc
4	Jamabces
5	Emmabca

I want

ColumnA	ColumnB
1	Fred
2	Jane
3	Mark
4	James
5	Emma

I know that I can use this method: 

Text.Remove(text as nullable text, removeChars as any) as nullable text

But I can't work out what to put as the arguments if I want the function to work over a whole column.

Thanks 

[ppm1 · Accepted solution]

In the query editor, select your column and click on Replace Values in the ribbon. Just leave the 2nd field blank.

Pat

[Legend_11 · Accepted solution]

Try this one= Table.ReplaceValue(#"Changed Type","abc","",Replacer.ReplaceText,{"Column2"})

Hope this helps!

[ppm1 · Accepted solution]

In the query editor, select your column and click on Replace Values in the ribbon. Just leave the 2nd field blank.

Pat