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!”

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

I NEED A GOOGLE SHEET FORMULA TO USE AN IF FUNCTION FOR EXAMPLE IF A CELL CONTAIN S ANY TEXT AT ALL THEN ANOTHER CELL POPULATES A NUMBER AND IF THE NEXT CELL IN THE SEQUENCE CONTAINS ANY TEXT AT ALL IT WILL THE SAME NUMBER AGAIN IF ANY CELL IS BLANK IT ENTERS NOTHING AND JUST LEAVES THE OTHER CELL BLANK
Solved by O. C. in 11 mins
In the Database sheet, enter conditions in the criteria range for unoccupied two- and three-bedroom apartments that need to be remodeled. Enter criteria as text only, without use of quotation marks. Be sure to enter the criteria separately in rows 3 and 4. Please help with this.
Solved by T. L. in 30 mins
This formula is placed in cell C3. =IF(ISBLANK(H3),"", IF(B3="Complete","", IF(H3>TODAY(),IF(TODAY()+H3<>1,CONCATENATE("Due in ",TEXT(TODAY()+H3,"d")," days"),CONCATENATE("Due in ",TEXT(TODAY()+H3,"d")," day")),IF(H3=TODAY(),"Due Today","Overdue")))) When the above formula is run and H3 is today or today-1, then the result in C3 is correct. When H3 is today+1 for example, the result in C3 is "Due in 9 Days". I cannot figure it out ?
Solved by B. U. in 16 mins
I have a cell that is conditional formatted to change colour when a certain value, i want to add another rule that will override this when a different cell has certain text in it, is this possible?
Solved by F. C. in 24 mins
Dear sir , I want to know that how we can get the formula text only of a cell in other cell.
Solved by X. U. in 27 mins
I need to find text with specific uppercase letters, example: filter "FR" from a cell that might for example contain: "lego set 2 | TEST BE FR US DE"
Solved by I. F. in 18 mins
When saving an excel file as a pdf, some cells end up blank on the pdf when they contain text on the excel sheet/file.
Solved by K. A. in 29 mins
When saving an excel sheet as a pdf, some of the cells appear that have text on the excel sheet appear empty in the pdf
Solved by K. B. in 28 mins
In cell Q3, nest the existing VLOOKUP function in an IFERROR function. If the VLOOKUP function returns an error result, the text “Invalid Staff ID” should be displayed by the formula. (Hint: You can test that this formula is working by changing the value in cell Q2 to 0, but remember to set the value of cell Q2 back to 1036 when the testing is complete.)
Solved by S. E. in 29 mins
I would like a formula where a text in one cell returns a the value from two different formulas.
Solved by F. Q. in 18 mins