Get instant live Excel expert help with Text Functions

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!

I am trying to get a column of percentage (GRADES) using the COUNTIF function to excel count cells with value or 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")

I need help inexcel conditional formatting based on another cell color. In the file, the cell 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.

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

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.

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.

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?

Need help with a google sheet formula. Trying to use countifs with multiple text criteria and a different cell that do not equal zero.

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?

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.