david gabra
Member
Hi
I need a macro that will remove unwanted spaces for there is a space of 1 between each word.
Bad
"3.1.13
In addition to obtaining customer approval, application service requests for configuration changes submitted by Managed Service Providers (MSP) are
approved by a Customer Adoption Team (CAT) Manager per region, ifrequired, before configuration changes are applied.
Applicable Trust Services
Good
CC8.1: The entity authorizes, designs, develops or acquires, configures,documents, tests, approves, and implements changes to infrastructure, data, software, and procedures to meet its objectives. Exceptions noted The control was not designed and implemented to provide the ability for the configuration changes to be identified for the required review and approval"
how can i do that in one go for the WHOLE SHEET
thanks
David.
I need a macro that will remove unwanted spaces for there is a space of 1 between each word.
Bad
"3.1.13
In addition to obtaining customer approval, application service requests for configuration changes submitted by Managed Service Providers (MSP) are
approved by a Customer Adoption Team (CAT) Manager per region, ifrequired, before configuration changes are applied.
Applicable Trust Services
Good
CC8.1: The entity authorizes, designs, develops or acquires, configures,documents, tests, approves, and implements changes to infrastructure, data, software, and procedures to meet its objectives. Exceptions noted The control was not designed and implemented to provide the ability for the configuration changes to be identified for the required review and approval"
how can i do that in one go for the WHOLE SHEET
thanks
David.