Now Remove leading apostrophe from numbers with Text to Column.
![how to remove ms works spreadsheet converter how to remove ms works spreadsheet converter](https://scoreintl.org/wp-content/uploads/2019/01/Jorielys-Reynoso-Done-11-2019-square-2048x2048.jpg)
And later, when you supply that to REPLACE function, it replaces space with no blank option & thereby removing only leading space in a text. Insert a new column to the right of the data to modify. If you have more than one column with your "text. Use the formula for remaining texts using Ctrl + D shortcut keys.