Get instant live expert help on I need help with excel vba split string

“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

Possibly creating some code string formula to help split jumbled data, hard to explain
Solved by T. J. in 19 mins
How do I find all formulas in 32 sheets over hundreds of rows that contain a partial string such as "This Company" where the formula looks like "=if(H2 = "This Company", "Yes","No"). This is a bit more complicated, but the upshot is that I need ti use VBA to locate formulas where the partial contents match a specific string. Any suggestions?
Solved by X. C. in 28 mins
Search thru Column H and Column I, and IF the cell CONTAINs STRING A, STRING B, OR STRING C, return VALUE 1 OR if cell CONTAINs String D, String E, OR STRING F, return VALUE 2, OR if cell CONTAINs String G, OR String H, return VALUE 3 Otherwise, return UNKNOWN.
Solved by T. H. in 22 mins
i want to split main excel sheet to sub sheets
Solved by T. D. in 21 mins
MY QUESTION IS ABOUT: Fixing Formulas DESCRIPTION: Search thru Column H and Column I, and IF the cell CONTAINs STRING A, STRING B, OR STRING C, return VALUE 1 OR if cell CONTAINs String D, String E, OR STRING F, return VALUE 2, OR if cell CONTAINs String G, OR String H, return VALUE 3 Otherwise, return UNKNOWN.
Solved by M. H. in 20 mins