Luis Ah Hoy Jr
New Member
- Joined
- Mar 15, 2017
- Messages
- 5
A fellow worker sent me a spreadsheet full of cells formatted in such a way that it makes it difficult to remove some of the spaces.
For testing purposes, here's the file:
Uploadfiles.io - remove all spaces.xlsx
In this example, I have this text string in cell A1: " 6403 "
I want to remove all spaces so that it only remains as: "6403".
In this case, the TRIM() and the SUBSTITUTE() methods only work to eliminate the spaces after the number, but they both fail to eliminate the spaces before it.
Any idea?
For testing purposes, here's the file:
Uploadfiles.io - remove all spaces.xlsx
In this example, I have this text string in cell A1: " 6403 "
I want to remove all spaces so that it only remains as: "6403".
In this case, the TRIM() and the SUBSTITUTE() methods only work to eliminate the spaces after the number, but they both fail to eliminate the spaces before it.
Any idea?