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