For Tom Urtis, Deleting spaces with VBA code

[olivier]

Tom

Thanks for your response

I was not specific enough in my needs; I want to delete spaces before and after a text but I don't want to delete spaces inside the text; for instance, for cost of product, I want all the spaces before and after deleted but not the ones between cost and of and of and product

Thanks

 

[Tom Urtis]

Would the TRIM function help then? Something like
=TRIM(A1)

Then you can copy it down, and paste special values over the formula'd range. Would that work?

Tom Urtis

 

[olivier]

Tom

Yes it works

Thanks