Get instant live expert help on I need help with vba length of string
“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 need these formulas in excel format (Length)2+ (Change in Height)2).5 10% is Design Standard (Length of Rake)*Catenary % Parameter of the Catenary C *(cosh ((L/2)/C)-1 C *(sinh ((Length of Rake)/C) Sum of Arc Lengths (Length of Rake * (Catenary) *0.67 Sum Areas of Deduction
Solved by A. H. in 20 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
FORMULA TO PERFORM A MATHEMATICAL EQUATION ON A SET OF NUMBERS WITHIN A STRING OF NUMBERS, THEN REPLACE THE SET OF NUMBERS WITH THE MATHEMATICAL RESULT IN THE SAME STRING OF NUMBERS (EXAMPLE: 123456 STRING OF NUMBERS, & MATHEMATICALLY REDUCE THE MIDDLE NUMBER OF 34 BY 1, THEN REPLACE THE ANSWER TO THE ORIGINAL STRING RESULTING IN 123356)
Solved by D. J. in 30 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
What formula do I use to look into the contents of a cell for a specific string of characters, and count the number of cells that have that string?
Solved by I. A. in 24 mins