Get instant live Excel expert help with Text Functions

I need help with a formula, I have written one but need to add something else on and just can't seem to work it out? The formula in M9 is:=IF(OR(L9="No Date",L9="Enter Date Here!",L9="-"),"",SUM(L9,730)), What i'm asking is if any of the text is entered in cell L9 then cell M9 will be blank and just do the sum, however I now want to change it, if L9 says "No Date" then M9 displays "Not required". I have another formula in L9 already, which is:=If(ISNA(VLOOKUP(D9,Inputs!S:AE,9,false)),"-",VLOOKUP(D9,Inputs!S:AE,9,false)) this is carrying information across from another sheet. Help???

Hi there, I would like help highlighting fields in my spreadsheet. As you will see on the attached document, the cell is annotated using the following format: <span class="coded_lhs"> text </span> <span class="coded_keyword"> text </span> <span class="coded_rhs"> text </span> Is there any way for me to write code that basically highlights anything between LHS in red, keyword in yellow, and RHS in green?

This is a continuation of a session from yesterday. There are some problems with the file, which are detailed in the pink text box on the "Daily Entry" tab of the workbook. Needs a macro expert to correct it please.

Hi, I am trying to do a count if formula, and stuck. I have two worksheets running, one as a detailed data and the other as a summary page. I am using a drop down validation box to select data (text) and these text data allocations have a number allocated to them. I want to SUM all the data (numbers) that have the same validation data selected to give a total summary. Thanks for the help

hi i have a problem with converting text to numerical formulas

I need to import a text file into excel for my employee list. I know there is supposed to be 2069 employees, however since there information is contained on multiple lines (2-3) it imports there info on multiple one instead of one. I attached my best attempt.

Hi there, I have 2 spread sheet. Sheet 1 has 6 digit number in one column and sheet 2 has column which has lot of text(Which has number of sheet 1 also) in each text field. I want match number of sheet 1 from the number mentioned in sheet 2 text field. There are about 22k entries i need to validate. Can you pls suggest quicker option?

I need to return a text value from a linked sheet based on multiple criteria

Hello. I want that the rows would be automatically adjusted by height to show the wrapped text completely. And when another cell automatically fills it adjusts the height to show the contents completely. (The cells width are fixed) Thanks

Need to make excel count cells with specific text