Get instant live expert help on how to trim text in excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
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'm trying to adding text of multiple cells and trim the irrelevant parts.
Solved by D. Q. in 15 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
In cell D5 use the TRIM, LEFT, and FIND text functions to extract the guests first name from cell A5. AutoFill the function down to D22.
Solved by C. U. in 16 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