Get instant live expert help on I need help with vba excel trim

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

=IF(G10="Yes","Match Override",IF(EXACT(TRIM(B10),TRIM(F10)),"Match","No Match")) How can I clean AND trim in this formula?
Solved by O. B. in 18 mins
I need a trim/clean/substitute combinations to remove the excess spaces in column B in the trim data worksheet
Solved by Z. Y. in 23 mins
I have a PDF document that I'm exporting into excel that comes all messed up. I can fix most of the problems with formulas and VBA, but there's one I just can't seem to fix. I'll paste it at the end of this message, but explain it a little more first. It exports with a number, then a lot of spaces, and then my text. All I need is the text. I tried using the TRIM and Substitute formulas and it didn't work. I also tried the RIGHT formula, pasting as values, and then using Trim, but it doesn't work either. Any ideas?
Solved by A. H. in 22 mins
trying to trim and concaternate some info
Solved by V. U. in 22 mins
I'm trying to adding text of multiple cells and trim the irrelevant parts.
Solved by D. Q. in 15 mins