Get instant live expert help on I need help with excel trim spaces
“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 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
In cells B13:B20, imported data from the rating system combines the manager's raise recommendation of High,Standard, or Low followed by the manager's notes. In cells J3:J10, how do I use a combination of text functions to return just the manager's raise recommendation of high, standard, or low? The values returned should not have extra spaces before or after the word. The names in A3:A10 are in the same order as A13;A20.
Notice the text pattern is always the recommendation followed by a space. Be sure to Trim any extra spaces.
Solved by V. F. in 23 mins
I need to get the spaces out of my excel documents. I have two
Solved by G. C. in 28 mins
trying to trim and concaternate some info
Solved by V. U. in 22 mins