This tutorial explains how to use the new Microsoft Excel Online Co-pilot tool to quickly remove spaces in your data and make your lookup functions work.
- Lookup functions like VLOOKUP and XLOOKUP can have problems when your data includes spaces.
- Spaces at the beginning or end of text strings, or extra spaces between characters, can all cause issues.
- To solve this, go to the “Data” tab and click on the “Clean Data” button.
- Excel will then identify ranges of cells that might have issues with spaces.
- Click “Apply” to fix the spacing problems.
This process is a fast and new alternative to using the TRIM and CLEAN functions, which have been the traditional method of addressing this issue.