I have a column with numbers I got from a web page table. There are two spaces in front of most of the numbers. I need to have all of them removed. I tried TRIM and that made it look like they were gone but then if I used a formula with the new cell it looked just the same. Is there a way to remove extra spaces before a number?
Chuck.
Re: Remove Spaces, Trim?
very old post but maybe it will help for others
try Power Query to trim leading and trailing spaces and replace multispaces to single space
@Sandy666: As old as it is, the OP did not mention which space character. TRIM() should have cleaned up any CHAR(32) space characters from the text. Because the OP says that the data were from the web, I suspect that these were CHAR(160) space characters that TRIM() and CLEAN() don't work with. As a clarification, does Power Query work at cleaning CHAR(160) spaces from data that Excel's built in functions don't?
Originally Posted by shg
@MrShorty,
just like you said, Power Query TRIM can be used with char32, 160 or any other. you can trim zeroes, letters and so on, it depends on you
I use TRIM as a key word, not as an excel function name
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks