Get instant live Excel expert help with Text Functions

I need help counting the text in cells from one worksheet and putting that number in another worksheet in the same workbook. For example: If cells D2:D35 shows urgent and cells G2:G35 shows H T or Z, I need to count how many T's are urgent and that value to fill the cell I need it to fill.

I need a formula or a process that will take a text from one cell and convert it into a numeric value in another cell.

I want to learn how process a long list of data into two columns but many of the lines of data exceed page width. I am following a 10 minute tutorial from a specialty software company I have imported a long list into column A . Each entry has a "number of options " associated with it. I am using text to columns to set up the 2 columns. One with the data the other with the numeric figure associated with it. I have seen this special step done, when data exceeds page width, and will recognize how when I see it. The tutorial is available but this should not be needed

I need a formula to compare a number from one cell with a list of numbers, and if they are equal, enter the text adjacent to the matching entry in the list.

Help please. I have two sheets, one contains a column that has a list of common errors, the other has a column from a log file that has all the errors. I need something that will check through all the errors and return a count of lines that do NOT contain any text from the common errors. In other words lines that have unknown errors. Additionally it would be useful to highlight the lines in all the errors to show unrecognized errors in red. Any ideas?

Hi, I need to create a pie chart that looks clean, I don't like the current callouts in the version I've created, I'd prefer just simple lines to text callouts vs the more cartoon bubble style callouts I have now

I need formula that look column d and compare with Colum e how many day has pass before complete. Colum d will be fill with text complete or a number of priority

I need a formula that uses 4 columns as a reference to locate dates in another sheet. I have Program(text), Phase(text), SiteID(numeric) and Milestone(text) and using those 4 criteria, they need to be able to pull 3 dates from the data sheet, Baseline, Forecast and Actual and have them in 3 separate columns into the formula sheet

I want to create a formula that checks Cells H8:H14, and count if cell contains text, if yes then adds 1 and if no then it adds 0 to the total count which is in cell J15... So essentially, J14=0+1+1+1 and so on so forth, adding one to the total if the corresponding cell contains text, and adding 0 to the total if the corresponding cell does not contain text...

How do i autocomplete in a column and be able to skip down a few cells and then have excel autocomplete in that cell? ie: I can fill a cell with "Revised", skip down a few cells and put "Completed". I then need to skip down a few cells in that column and have excel give me a predictive text of either of those two entries depending on which first letter i type. I know it can be done because it does it other columns but i cant make it do it in them all.