Extract number values from column

I tried out the ExcelGuru Link above, and it worked like a charm! Assuming you already have your data source setup, you can use the advanced query editor to add the cleansing steps.

1. To the beginning, add your variable:

(LET)

CharsToRemove = List.Transform({32,46,33..45,47,58..126}, each Character.FromNumber(_)),

2. At the end of your steps, add the following:

First, Add comma to the last line of your existing M query, before "IN", so it knows to continue when it gets to that line...

#"Changed TypeX" = Table.TransformColumnTypes(#"Previous M Step name",{{"Field to Convert", type text}}),
#"Added CustomX" = Table.AddColumn(#"Changed TypeX", "New Field Name", each Text.Remove([Field to Convert],CharsToRemove))
in
#"Added CustomX"

That should work, just swap out the bold text with your field names!