Forum Discussion
BassG
Helper I
Helper IIs it possible to Trim leading/trailing spaces using transform data?
Using an excel file as my source, there's a column called "Incident" which has the types of incident such as "Physical Assault", "Threatening behaviour", "Throwing an object" & so on. There's 11 dif...
BassG ,
In Power Query there is a function called Text.Trim.
https://learn.microsoft.com/en-us/powerquery-m/text-trimYou can create a new Custom Column, apply this function to your original column then, if desired, delete the old column.
Hope this helps.
Regards,
sarah2
Helper II
Helper IIA better way to do this is a custom delimeter and make it ", " (comma space)