Microsoft 365 / Azure Clean Up Leading/Trailing and Full-Width Spaces in Excel: Fixing Inconsistencies with Office Scripts
Use Office Scripts to format only string values within an Excel table by cleaning up leading and trailing spaces, full-width spaces, and consecutive spaces while skipping formula cells.