Get instant live expert help on I need help with excel trim text
“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
I'm trying to adding text of multiple cells and trim the irrelevant parts.
Solved by D. Q. in 15 mins
=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
In cell D5 use the TRIM, LEFT, and FIND text functions to extract the guest’s 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
trying to trim and concaternate some info
Solved by V. U. in 22 mins