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 want to set the data labels on a chart to a defined size so that the text will not overlap.
Solved by D. J. in 12 mins
Hi I'm just having trouble with the format of 2 strings. Looking to use a vloopup from a couple Player to another sheet in Excel which has the same player name. Testing to see if the data matches up it comes back false. Both columns I have made sure the data is converted the text and also tryed using the CLEAN adn TRIM functions. Any other ideas?
Solved by O. H. in 24 mins
I have a spreadsheet created. However, I need the formula to work off of text too, not just a number. This is my formula: =IF(AND(K5>0,L5>0,M5>0),ROUND(VLOOKUP(TEXT(K5,"00.000")&TEXT(L5,"0.000"),'Shape, Support Tooling'!A2:G19,5+M5,FALSE),0),"") Where M5 is, is where I would need the column to have words in it instead of going off numbers
Solved by E. U. in 12 mins
im trying to find the top ten sales for the month in some sales so i can put a green fill with a dark green text to the top 10 values
Solved by B. A. in 28 mins
I have three different sheets within one Google Sheet. One of those sheets contains a column of dates. I want to use countifs excel. The date must be greater than or equal to a cell on another sheet, and a cell next to them must match text from another sheet. I am attempting to use a countifs formula, however, I am not having any luck.
Solved by K. L. in 12 mins
I am having trouble putting together text strings with an index match excel
Solved by C. J. in 13 mins
I'm trying to use conditional formatting in excel based on another cells to color code cells that are greater or lesser. However there is text in the cells and the conditional formatting isn't correctly color coding values that are higher or lower.
Solved by Z. F. in 28 mins
I'm working on a time sheet for hours to be work. Then I'm displaying the hours in a schedule which is for the employees to read. If employee is scheduled for a 15 min break, I want the schedule to present the code "B" for break; if employee is scheduled for 30 min or longer, I want the text to "L" for lunch. The formula works for AM but any shifts in the PM, I get a value of "FALSE." This formula works for AM only: =IF('Master Hours'!BA16>TIMEVALUE("00:15"),"L", IF('Master Hours'!BA16<TIMEVALUE("00:14"),"", IF('Master Hours'!BA16=TIMEVALUE("00:15"),"B")))
Solved by V. J. in 19 mins
Hi, I'm having a problem with a pivot table that wont produce the summery of the data that i require. I need to be able to filter the 'divisions' to provide the number of 'yes', 'no' and 'n/a' to a given question 'Q1', 'Q2' etc. When I have used a pivot table there doesn't appear to be enough options to count the number of text answers. Instead it only counts the number of one of the columns and replicates the data?
Solved by Z. B. in 19 mins
Q1: On the tab labeled CA I have column E highlighted. Is there a way to add to the Macro after it completes the "Generate" function to clean up the "CA" tab and delete rows that include specific text in column E? Q2: When using a macro to auto pull data(I do not have it added yet) to a tab and I want it to add it to the next empty row, how do you write that? For example on the "Avaya" tab, if my macro auto pulls the data, and I wanted the data to dump into row 45 as it is the next empty row, how do you write that into the macro?
Solved by Z. S. in 26 mins