• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

need a macro that will remove unwanted spaces for there is a space of 1 between each word. (will do for the whole sheet)

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.
 
Here's a code link which should do what you need!

If you are looking for shorter version of code instead then:
 
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

What is 'Bad' about what you posted? I do not see any instances of more than one space between words.
 
Please post a sample sheet with some data. Thx


Please refer to sample attached exel - bad formatting F6 - Fixed G6

I would like a macro to fix - so I can run on hudreds of cells, and save me ma naually fixing.

All the macro so far do not fix my issue.

thanks
 

Attachments

  • bad formatting.xlsx
    15.3 KB · Views: 6
I do not understnad. I need to manually go to the cell and go the end of each sentnce and press delete to change the sentence to a nice format.
I need help for that please.
Maybe space space is not the correct word - but need help to prevent me doing manaually.
 
Yes indeed !​
As Excel is very not a words processor but it is easy to remove all Line Feed characters and can be achieved without VBA !​
But as your need seems not to delete them all so you must well elaborate your strategy like it must be within the initial post​
with at least a well representative workbook …​
 
Look at the attachment - I just want to know if there a quick way to change the text within the cells it looks presentabl e - thanks
 
Yes, that's exactly my previous post proposal but not exactly the expected result which logic / strategy is still expected …​
 
Back
Top