spaces in values

[daveyc18]

is there an easy way to get rid of the spaces in PQ?

Loading Google Sheets

 

[alansidman]

See if this link is helpful

How to remove spaces in Power Query

This post shows how to remove spaces in Power Query using (1) Trim transformation (2) Custom function.

exceloffthegrid.com

 

[daveyc18]

See if this link is helpful

How to remove spaces in Power Query

This post shows how to remove spaces in Power Query using (1) Trim transformation (2) Custom function.

exceloffthegrid.com

looks like you'll need to do a find and replace using char 160

 

[alansidman]

Second Attempt that seems to work with your sample

let
    Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}}),
    RV= Table.ReplaceValue(#"Changed Type","#(00A0)","",Replacer.ReplaceText,Table.ColumnNames(#"Changed Type"))
in
    RV

SAMPLE (2).xlsx
	D	E	F
1	Column1	Column2	Column3
2	- 0.01	-2,195,242,500.01	-2,195,242,500.00
3	-3,854,864,559.50	-1,630,265,459.01	2,224,599,100.49
4	-7,300,774,935.53	-5,800,826,166.27	1,499,948,769.25
5	- 119,448,676.97	- 69,226,324.31	50,222,352.66
6	-2,384,140,065.40	-2,507,212,271.80	- 123,072,206.40
7	- 51,045,800.03	- 762,081,760.03	- 711,035,960.00
8	- 135,400,000.01	- 0.01	135,400,000.00
9
10	Column1	Column2	Column3
11	- 0.01	-2,195,242,500.01	-2,195,242,500.00
12	-3854864559.5	-1630265459.01	2,224,599,100.49
13	-7300774935.53	-5800826166.27	1,499,948,769.25
14	- 119,448,676.97	- 69,226,324.31	50,222,352.66
15	-2384140065.4	-2507212271.8	- 123,072,206.40
16	- 51,045,800.03	- 762,081,760.03	- 711,035,960.00
17	- 135,400,000.01	- 0.01	135,400,000.00
Sheet1