•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Trying to remove invisible characters (go to special -> blanks not finding all blank cells)
Hi everyone, I’m at my wits end with this one. I’ve copy and pasted data a large chunk of data from one excel sheet to another that has a blank line or two between meaningful data. I want to remove all those blank cells, but when I use go to special -> blanks it says there isn’t any. I’ve tried using CLEAN, tried using TRIM, tried using both, tried using CODE to detect what character is in the cell, it comes back as #VALUE.
The way the data was pulled was with the formula IFERROR(TEXTBEFORE(A1, “ - “,1)””). It isn’t treating “” as blank for whatever reason. Maybe an extra important detail: the original file is a .xls; new book is .xlsx. Using Office 365.
Any help is appreciated!
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#generative AI for data analysis
#big data management in spreadsheets
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#Excel compatibility
#financial modeling with spreadsheets
#Excel alternatives
#rows.com
#natural language processing for spreadsheets
#AI formula generation techniques
#large dataset processing
#no-code spreadsheet solutions
#formula generator