![]() ![]() Remove Extra Spaces in Excel using FIND and REPLACE. ![]() To be on the safe side, it is always a good idea to clean your data and remove spaces in Excel. In this example, it was easy to spot the issue in such a small data set, but imagine having to check this for thousands of records. You might not be able to spot the difference with the naked eye that there is an extra trailing space in the name that is causing this error. Now have a look at what happens when I use a VLOOKUP function to get the last name using the first name. Leading, trailing, or double space between text could lead to a lot of serious issues.įor example, suppose you have a data set as shown below: There are many ways you can end up with these extra spaces – for example, as a part of the data download from a database, while copying data from a text document, or entered manually by mistake. I can’t think of a situation where you may need these extra spaces, but it often finds its way into the excel spreadsheets. Leading and trailing spaces in Excel often leads to a lot of frustration.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |