Hello Everyone,
I am looking for a macro that could do two things, if anyone is interested in creating something.
1.) Remove all extra spaces between text. Meaning there should be only one space between each word.
2.) If there is one or more spaces at the BEGINNING or at the END of a cell, remove them completely.
I have seen many variations of similar macros but honestly for some reason I can't seem to get any of them to work how I want them to.
I thought that the "Trim" syntax was designed to remove spaces, but the only uses I have seen were for specific words to have the spaces trimmed.
Couple Of IMPORTANT Pieces Of Information
A.) I would like the two items above to be part of the same macro, if possible.
B.) I am looking for the simplist macro, with the intent that I could add it to run at the end of certain already existing macros that I have.
C.) With keeping the above B.) request in mind, I am looking to add this to macros that I already have, some are based on applying a macro to an ENTIRE SPREADSHEET and others are based on SELECTION. Not sure if this would require two different pieces of code to achieve or if it can be just one piece that could be added to either type of macro?
Thank You to anyone who reads this and gives it a try.
I am looking for a macro that could do two things, if anyone is interested in creating something.
1.) Remove all extra spaces between text. Meaning there should be only one space between each word.
2.) If there is one or more spaces at the BEGINNING or at the END of a cell, remove them completely.
I have seen many variations of similar macros but honestly for some reason I can't seem to get any of them to work how I want them to.
I thought that the "Trim" syntax was designed to remove spaces, but the only uses I have seen were for specific words to have the spaces trimmed.
Couple Of IMPORTANT Pieces Of Information
A.) I would like the two items above to be part of the same macro, if possible.
B.) I am looking for the simplist macro, with the intent that I could add it to run at the end of certain already existing macros that I have.
C.) With keeping the above B.) request in mind, I am looking to add this to macros that I already have, some are based on applying a macro to an ENTIRE SPREADSHEET and others are based on SELECTION. Not sure if this would require two different pieces of code to achieve or if it can be just one piece that could be added to either type of macro?
Thank You to anyone who reads this and gives it a try.
Last edited: