Tuesday 2 February 2016

Microsoft: Remove Extra Spaces in a Cell in Excel


The following formula allows you to remove the unwanted spaces in a cell:
Substitute(A1," ","")

No comments:

Post a Comment