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

How do I create a function to replicate text in a cell if a preceding​ cell has text that is BOLD?
Solved by O. H. in 13 mins
How do I setup excel conditional formatting based on text in another cell?
Solved by E. Y. in 16 mins
Need to modify an If formula to display text only at a certain value
Solved by C. J. in 28 mins
Hello, I'm working on a spreadsheet and I wish to have both formula and text in the same cell for example: [=(A1+B1) cats] I hope you can help me. :)
Solved by F. H. in 16 mins
Sumif help to display text once the cell is over a certain value
Solved by M. H. in 17 mins
I can't use my new data for different value field settings in the pivot table apart from count, it says can't summarise this data as it's not a supported calculation for text data types
Solved by D. F. in 14 mins
In cell L2 in the Valuable worksheet, enter a nested logical function to display Highly Valuable if either condition is met: *The release date is on or before December 31, 1994, or *The sold-out status is Yes, the percentage increase in value is at least 500%, and the Edition Size was less than 700. Enter an empty text string if the two conditions are not met.
Solved by I. F. in 21 mins
This request is for the tab “TrueUp AddProd”. I require a text to be calculated on Column R “Tier”. If the “Product Family” in Column Z, matches the Product Family on tab “Tier”, list the value of the Tier on column B. If no product family match is available, list “Core”.
Solved by T. J. in 16 mins
Need to have formulas perform a match on specific text from another tab.
Solved by Z. H. in 29 mins
This request is for the tab “EA Agreement Renewal”. I require a text to be calculated on Column R “Tier”: If the “Product Family” in Column AB, matches the Product Family on tab “Tier”, list the value of the Tier on column B. If no product family match is available, list “Core”. I can’t get the formula on column R “Tier” to work. For some reason, only the value of “Core” is appearing.
Solved by G. F. in 28 mins