• 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.

Replace special character in whole column

YasserKhalil

Well-Known Member
Thanks .. But using the Trim doesn't fix that
Code:
.Value2 = Application.Trim(v)
Is there a way to fix the output as appeared in Post #46?
 

shrivallabha

Excel Ninja
Thanks .. But using the Trim doesn't fix that
Code:
.Value2 = Application.Trim(v)
Is there a way to fix the output as appeared in Post #46?
TRIM will reduce more than one spaces to one when they exist between words and it will remove all extra spaces if they are preceding or trailing the string. If there's one space remaining between words then applying TRIM won't result in anything.
 
Last edited:
Top