Get instant live expert help on how to trim data in excel

“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
trying to trim and concaternate some info
Solved by V. U. in 22 mins
=TRIM(IF(LEFT(E30, 1) = "O", SUBSTITUTE(E30, "Online Archive - ", ""), SUBSTITUTE(E30, "In-Place Archive -", "")))
Solved by D. J. in 21 mins
I'm trying to adding text of multiple cells and trim the irrelevant parts.
Solved by D. Q. in 15 mins