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 have a text file with lots of data separated by a comma, the issue is when I import it adds the data as a row rather than a column, so I basically need the data to be transposed before being added. Help!
Solved by Z. D. in 12 mins
I am trying to get a column of percentage (GRADES) using the COUNTIF function to count the number of cells with text, then SUM only those cells. Here's the formula I have so far, but it is not working; =COUNTIFS(C8:C41,"<>"&"",F8:F41,"AVERAGE")
Solved by M. E. in 30 mins
I need help in formatting cells that will not show based on there not being text in the 'Student Column", but the cell color coded with a uniform color if no data appears.
Solved by O. F. in 27 mins
When I go to insert the chart it will not pick up all my cells and I want part numbers and it keeps converting the parts to numbers insert of like text although I formatted the cells to text
Solved by F. A. in 22 mins
I have a conditional formatting that is =LEN($W$2:$W$24)<15 , what I'm trying to do is highlight those cells that have more than 15 characters which could be text or numbers. Help the formula above highlight all in the column.
Solved by K. S. in 14 mins
Data is seemingly arbitrarily split into two columns in the pivot table, and I can't figure out why. In the purple worksheet "Lecturer totals T1" you'll see two columns for "All". On "Lecturer totals 01-17" you'll see "BaL" and "HLS" twice. On "Lecturer totals T2 & 3" there are two columns for each of "All", "BaL" and "HLS". On the green "Faculty totals T1" worksheet, "All" has two entries. There are similar cases in the other worksheets. I've tried applying the "=ISNUMBER" function to each of the cells containing "All" in the data (the red worksheets). These return a FALSE reading, which (if I understand correctly) means that they're text, which is what they should be. Depending on when you answer, I might not be able to continue the conversation before tomorrow around 0900.
Solved by Z. Y. in 29 mins
The identical value in the data is seemingly arbitrarily split into two columns in the pivot tables. On the attached workbook, the red worksheets contain the data; the other colours are the pivot tables. As an example, I checked each cell containing the value "All" using the "=ISNUMBER" function. All returns were "FALSE", which if I understand correctly means that the value is text. This is as it should be. The purple worksheet "Lecturer totals T1" contains two columns for "All", "Lecturer totals 01-17" contains two columns each for "BaL" and "HLS" "Lecturer totals T2 & 3" contains double columns for all these three values. The same is true for the equivalent green "Faculty totals" and orange "Student totals" worksheets. How can I ensure that the pivot tables only contain one column for each of these values?
Solved by E. D. in 13 mins
Need help with a google sheet formula. Trying to use countifs with multiple text criteria and a different cell that do not equal zero.
Solved by S. J. in 18 mins
Hi there, I'm trying to create a drop down menu that has text options with numerical values attached. I'm trying to create a calculator for my website. The word male is to represent the number 5 and the word female is to represent the number - 161. I've been trying for hours to get this sorted with no luck, can you help?
Solved by E. Y. in 23 mins
I have 2 drug list column A and B in Scan.xlsx. If column "A contains" the word from Column B then keep it if not delete. For example from the list, if column "b" contains the drug Acetemra but in column "A" the text reads Acetemra pfa then I want it to be picked up.
Solved by I. D. in 18 mins