LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 219
Default "T" function broken?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can you make a "split" or broken y-axis on a graph in Excel? question Charts and Charting in Excel 2 August 30th 07 11:46 PM
Excel 2007 Bug - "Locked" Property is Broken for Shape Objects NOSLOW Excel Programming 0 August 21st 07 07:01 PM
Excel 2007 Bug - "Locked" Property is Broken for Shape Objects NOSLOW Excel Programming 0 August 21st 07 07:01 PM
look for a pipeID in a column and returns "broken" result Khoshravan Setting up and Configuration of Excel 4 May 5th 06 09:55 AM
"broken" y-axis in Excel charts burnsbyrne Charts and Charting in Excel 1 April 26th 06 04:26 PM


All times are GMT +1. The time now is 08:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"