trim values?

[daveyc18]

when i copy and paste numbers from an email,

i'm getting a bunch of spaces in front of the number, behind the number

the trim function doesnt work since it's for text...any way to get rid of spaces for values?

 

[daveyc18]

thanks guys

would there be a way to do this in power query easily?

 

[Fluff]

I know very little about PQ, so couldn't say.

 

[JvdV]

Strangely enough, when I loaded the data into PowerQuery, you'd normally set column to data type 'Text'. When doing so, you'd create the option to use the advanced option under the 'Replace Values' option, allowing you to select the non-breaking space. Funny enough, setting the different columns to data type 'Text' was enough for PQ to auto-change the non-breaking spaces into actual spaces. For me a simple replacement of spaces with nothing, changing data type back to 'Decimal Number' was enough to get the data correctly.