Forum Discussion
Solved
Remove extra spaces behind names
I have this list of machines, where some have a group of spaces behind the names, and I'm trying to use this list in Power BI and merge it with another dataset. I tried to used find/replace to remove...
Hello RULIANA ,
You can use the Trim command under the Format drop-down on the Transform ribbon. That will remove leading and trailing spaces, but will keep the data type as Text and will retain the leading 0 and the space in the middle of the text.
The screenshot is from the Power Query editor in Excel, but it works the same in Power BI.
Hello RULIANA ,
You can use the Trim command under the Format drop-down on the Transform ribbon. That will remove leading and trailing spaces, but will keep the data type as Text and will retain the leading 0 and the space in the middle of the text.
The screenshot is from the Power Query editor in Excel, but it works the same in Power BI.