I’m running into issues with cleaning data within Excel files.

I’m cross referencing two Excel spreadsheets to get accurate store locations.

When I drop in my data (in column B) next to provided data (column C), it highlights almost all data values (including ones that do not match).

I’ve tried changing the number format (from general to number to text) and run into the same result. Any suggestions on how to fix this?

My work currently uses Microsoft® Excel® for Microsoft 365 MSO (Version 2405 Build 16.0.17628.20006) 64-bit.

​I’m running into issues with cleaning data within Excel files.I’m cross referencing two Excel spreadsheets to get accurate store locations.When I drop in my data (in column B) next to provided data (column C), it highlights almost all data values (including ones that do not match).I’ve tried changing the number format (from general to number to text) and run into the same result. Any suggestions on how to fix this?My work currently uses Microsoft® Excel® for Microsoft 365 MSO (Version 2405 Build 16.0.17628.20006) 64-bit.  Read More

​