For Tom Urtis, Deleting spaces with VBA code

olivier · Feb 19th, 2002, 11:24 AM

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 · Feb 19th, 2002, 11:42 AM

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 · Feb 19th, 2002, 11:47 AM

Tom

Yes it works

Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 19th, 2002, 11:24 AM	#1
olivier New Member Join Date: Feb 2002 Posts: 7	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

Feb 19th, 2002, 11:42 AM	#2
Tom Urtis MrExcel MVP Join Date: Feb 2002 Location: San Francisco, California USA Posts: 10,383	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

Feb 19th, 2002, 11:47 AM	#3
olivier New Member Join Date: Feb 2002 Posts: 7	Tom Yes it works Thanks