Excel Why Are SEC Edgar Numbers Showing as Text in Excel? - Episode 2654

[@erikguzik8204]

Thank you for the left handed mugs. Not sure I speak for all southpaw's out there. But it's nice that someone takes the time to make stuff for us... Note to mouse makers... Some of us use our left-hand on the mouse too.!!!! Personally I think they should fix the TRIM() function to clear char 32 & 160.

[@johnborg5419]

Thanks Mr Excel :)

[@drwarner]

Great vid as always, good catch! Bear in mind, the alt+code thing only works with a proper numpad, not with the top number row (at least on my system anyway) - bummer for those with TKL keyboards

[@DougAshley]

I always just copy the problem character from one of the cells that needs to be cleaned and then paste that into search & replace.

[@ennykraft]

I ran those messed up "numbers" through Power Query since I had the added problem that my decimal separator is a comma so Excel interpreted the numbers I pasted incorrectly. Thankfully with the regional settings I was able to clean up everything. Power Query ignored those dratted non-breaking spaces.

[@Quidisi]

I think another way would be to copy the offending invisible character, then paste it in this formula (first set of quotation marks): =SUBSTITUTE(A1," ","")

[@RamonantonioCerebro]

Thanks for the forecast! I have a quick question: My OKX wallet holds some USDT, and I have the seed phrase. (behave today finger ski upon boy assault summer exhaust beauty stereo over). How can I transfer them to Binance?

[@brianspiller9075]

but as a Macro.... Remember that the What is entered as a Ctrl+Space, or ALT+ 0160. or record and edit. Sub Code_160() ' ' Code_160 Macro 'Removes all Characters of Code 0160 from Active WorkSheet 'This Character Code is often included in copied or downloaded 'spreadsheet data that interferes with Excel evaluations. 'Add to the QAT with suitable Icon. Suggestion is the "Unhappy" Face Cells.Replace What:=" ", Replacement:="", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False End Sub