Remove extra blank spaces from text

You can use the =TRIM function to remove blank spaces before and after text. This handy function will clean your data and allow you to use the clean data in other functions such as =VLOOKUP. In the below example the original cell contents have blank spaces to the left. Using the trim function =TRIM(A2) in cell C2, I can remove them. 

No comments:

Post a Comment