istext

Hi, I've been trying to find a way to use conditional formatting for a the header if the column for that table contains non-numeric characters as I come across this happening when receiving exported data. I have tried using ISTEXT and ISNUMBER together with an IF statement but haven't gotten...

When I use the ISNUMBER or ISTEXT function for the whole cell, it gives me the correct true or false result. When I use the ISNUMBER OR ISTEXT with the right function to extract the last 3 characters it is giving me the incorrect results. I want Excel to see the the last 3 characters as if it is...

Hi I entered 1:00 and then 2:00 in cells B2 and B3, then in B4, I used = sum(B2,B3). <colgroup><col><col><col></colgroup><tbody> istext() time1 1:00 FALSE time2 2:00 FALSE total 3:00 </tbody> so far so good, then I highlight cells B2 and B3 and changed the format to "Text"...

Dear All! I've encountered a curiousity. A SAP download contains description within cells J to O. Both formulas, isblank and istext return "false". My goal would be to detect empty cells for deletion. All cells are formated manually as text and no value is shown when entering the cell...

Thank you in advance for your assistance. I somehow have not yet been able to apply conditional formatting: (a) for only cells with text, and (b) that text meets our criteria. - Cell A4 contains a Due Date - Cells A5-A10 contain actual completion dates - I want to highlight (e.g. fill green)...

Hi All. I have a cell where I have used both ws functions and VBA functions to test content. The cell appears to have no content, but still it is not empty. VBA: isemtpty(cell) returns false WS: isblank(cell) = FALSE code(cell) = #VALUE! istext(cell) = TRUE I'm in doubt about how to...

I have two columns of data, one which contains numbers and text (A), and the other which contains numbers only (B). I currently have this formula which sums the values in A based upon the condition that col B contains a text value. This works. =SUMPRODUCT(--(ISTEXT(A$25:A$1500)),B$25:B$1500)...

Hello, I have a rota sheet whereby shifts are written in as start time, finish time, and then a calculation for the hours. At the bottom I have another SUM formula to calculate total daily hours. However, within the total personal hours I have a VLOOKUP formula to check if the start time cell...

New to forums, so bear with me, please! These are the things I would like to accomplish with this Excel formula. #3 and #5 are not accomplished at this time. I included all goals, as when I keep trying different formulas and solve one problem, it seems to cause other goals to not be...

Hello, I have a macro that I use to test quantities of items. I would like to add a capability to this macro so that I can see if the cell it is searching contains text and if it does, to skip that cell and go to the next item. If it doesn't have text I would like it to check the quantity...