G gcunningham New Member Oct 29, 2012 #1 How do I remove the spaces in column cells if I want to do the vlookup function?
Luke M Excel Ninja Staff member Oct 29, 2012 #2 TRIM might be a good function to use. Removes the extra spaces.
F fred Member Oct 30, 2012 #3 hi Luke, What if I want to remove all the spaces not just excessive space? Trim would only remove double spaces or more down to single space. Fred
hi Luke, What if I want to remove all the spaces not just excessive space? Trim would only remove double spaces or more down to single space. Fred
F fred Member Oct 30, 2012 #4 Never mind. I found my own solution. Thanks for the inspiration. LEN(SUBSTITUTE(A1," ",""))
SirJB7 Excel Rōnin Oct 30, 2012 #5 @fred Hi! Without LEN to remove, with to get length of remaining after remove. Regards!