Get instant live expert help on I need help with vba trim function
“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
trim function is not working to eliminate the extra space at the end of the last word in the cell
Solved by E. E. in 18 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
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
Use the VBA Editor to create a new module. Type the following VBA code to create a custom depreciation function (be sure to include the blank lines after the first line and before the last line). Save and exit the VBA Editor. Function Depreciation (Value, Rate) Depreciation = Value * Rate End Function
Solved by F. C. in 11 mins