Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I've been trying different text functions for a spreadsheet I'm working on.
Came across the "T" function, but can't get it to work. (Isn't this a terrible name for a function, a single letter?) If I simply apply it alone, as in =t(B7) in cell C7, it seems to behave as described. If B7 is alpha, T returns the alpha string. It B7 is a number, it returns a blank. Ok. But if I put a LEFT function inside it to use it to determine if the leftmost character in a string is alpha or numeric, it goes kablooie! I.e., I put =T(LEFT(B7,1)) in Cell C7. If I put abc in cell B7, it returns the "a". Great. but if I put 222 in cell B7, it returns a 2! It should be blank since the 2 is numeric. So why does it return 2? I was going to wrap an IF statement around all this to determine if a string starts with a alpha or a numeric character, but this obviously wont' work. Is this Excel function just broken? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can you make a "split" or broken y-axis on a graph in Excel? | Charts and Charting in Excel | |||
Excel 2007 Bug - "Locked" Property is Broken for Shape Objects | Excel Programming | |||
Excel 2007 Bug - "Locked" Property is Broken for Shape Objects | Excel Programming | |||
look for a pipeID in a column and returns "broken" result | Setting up and Configuration of Excel | |||
"broken" y-axis in Excel charts | Charts and Charting in Excel |