Get instant live Excel expert help with Text Functions
“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
Looking for formula to determine a text continuous occured in range for 3 times or more
Solved by X. U. in 23 mins
Previosly chat with expert but not lost session without get know answer of formula
chat details below
Welcome 13:25Please explain which Text occurrence in a range you want to count? 13:26As I have mentioned that From Range C to N If Continously Needs Improvement or Poor Text found in a row excluding Blank cells then It should reflect as True in Column B 13:29true only if text (Needs Improvement or poor) should be occured three times or more in a range. 13:31Else it should return FALSE. Right? 13:32ya exactly 13:32Okay 13:32Let me fix it 13:3
Solved by M. W. in 20 mins
how can i extract specific words in a text in excel?
Solved by V. U. in 29 mins
The text on the spreadsheet doesn't open. It only showns the grey backscreen
Solved by Z. D. in 26 mins
how can a paste column B, into column C, as a text file without missing any number?
Solved by B. B. in 19 mins
I need to make this report workbook where text matching is required. Not only conventional matching but also partial matching. example is match "searching" in "search*", "this time" in "this*", "this time" in "this *" etc. Previous expert said it cannot be done.
Solved by K. Q. in 25 mins
I want to query data from sheet 2, so when I enter "1" which means semester 1 in cell b2, sheet 1 should give me the result for class 1 semester 1. Moreover, so when I enter "1" in cell b8, sheet 1 should give me the result for class 2 semester 1. Lastly, I want to copy the results of class 1 semester 1 into a new sheet, but when I do that, the tables will be pasted just as text or values and the link to the query will break.
Solved by Z. S. in 26 mins
I want to run a formula where:
if i vlookup based on cell1 and the returned value contains text found in cell2, then another vlookup will be run
Solved by C. W. in 25 mins
Need to extract date after the text "Last Submitted at" from Column I of sheet DATA
Solved by C. J. in 16 mins
I am not sure this formulas can even be written but here goes....
I need a formula that searches for a specific text in a column on another sheet. When it finds those that text in cells I need it to take the numerical value of another cell in the row(s) where that text was found and average all the occurrences together of those cells with the numerical values.
Solved by S. C. in 25 mins