1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Is there a quick way to remove a space in front of text in a cell?

When I used text to columns it kept a space causing my xlookup to return n/a. Is there a way to fix this without using formulas?

submitted by /u/Straighty180-
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#Excel
#remove space
#xlookup
#text to columns
#n/a
#cell
#formulas
#quick fix
#fix
#data manipulation
#data cleaning
#function
#text formatting
#spreadsheet
#input error
#cell reference