Replace special character in whole column

[YasserKhalil]

Thanks .. But using the Trim doesn't fix that

.Value2 = Application.Trim(v)

Is there a way to fix the output as appeared in Post #46?

 

[shrivallabha]

Thanks .. But using the Trim doesn't fix that

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

 

[Marc L]

But using the Trim doesn't fix that

I can't reproduce any of your issues on my side as all well work …​

​