excel函数:汉字转全拼
Welcome to another weekend in the 30XL30D challenge, and you're probably exhausted from a long week of Excel work, and yesterday's complicated example for the TRANPOSE function. For day 14 in the challenge, we'll examine the Excel T function
欢迎来到30XL30D挑战的另一个周末,您可能已经厌倦了漫长的Excel工作,以及昨天复杂的TRANPOSE函数示例。 在挑战的第14天,我们将检查Excel T函数
我们需要吗? (Do We Need It?)
The T function is one of the less useful ones. It tests a value for text, and other functions do the same thing, so do we even need T?
T函数是较不有用的函数之一。 它测试文本的值,其他函数做同样的事情,所以我们甚至需要T吗?
NOTE: You can have all of the 30 Functions content in an easy-to-use single reference file -- the 30 Excel Functions in 30 Days eBook Kit ($10). To decide, let's take a look at the T information and examples, and if you have other tips or examples, please share them in the comments.
注意:您可以在一个易于使用的单个参考文件中获得这30个函数的全部内容-30天电子书工具包中的30个Excel函数 (10美元)。 要决定,让我们看一下T信息和示例,如果还有其他提示或示例,请在评论中分享。
功能14:T (Function 14: T)
The T function returns the text from a value, or an empty string for no text.
T函数从值返回文本,或者从空字符串返回无文本。
![T00 T00](https://i-blog.csdnimg.cn/blog_migrate/9a969fe6f5b8bf5b0a7c4d0a08c1dd10.png)
您如何使用T? (How Could You Use T?)
The T function has very limited use, and could be replaced by other functions, such as ISTEXT. You can use T to:
T函数的用途非常有限,可以用其他函数(例如ISTEXT)代替。 您可以使用T来:
- Return text if value is text 如果值是文本,则返回文本
- Return an empty string if value is non-text 如果值是非文本,则返回一个空字符串
T语法 (T Syntax)
The T function has the following syntax:
T函数具有以下语法:
-
- value can be any value -- typed in the formula, or a cell reference value可以是任何值-在公式中键入,也可以是单元格引用
T(value)
T(值)
T陷阱 (T Traps)
The T function returns an error if the value is an error, unlike ISTEXT, which returns FALSE for errors.
如果值是错误的,则T函数将返回错误,这与ISTEXT不同,ISTEXT的错误返回FALSE。
示例1:测试值是否为文本 (Example 1: Test If a Value is Text)
I can't think of a situation where T would be preferable to another function, like ISTEXT. Let's compare the two functions, side by side, to see the results.
我想不出T比其他函数(例如ISTEXT)更可取的情况。 让我们并排比较两个函数以查看结果。
If a value is text, the T function returns that text. In the screenshot below, the T function is used in cell C4, to check the value in cell B4.
如果值为文本,则T函数将返回该文本。 在下面的屏幕快照中,单元格C4中使用了T函数,以检查单元格B4中的值。
=T(B4)
= T(B4)
That looks like a number in cell B4, but there's an apostrophe in front of it, so it's actually text. The T function returns the "1234" string. In column D, the ISTEXT function also tests the value in cell B4, and returns the result of TRUE.
在单元格B4中看起来像一个数字,但是它前面有一个撇号,因此它实际上是文本。 T函数返回“ 1234”字符串。 在D列中,ISTEXT函数还测试单元格B4中的值,并返回TRUE的结果。
=ISTEXT(B4)
= ISTEXT(B4)
![T01 T01](https://i-blog.csdnimg.cn/blog_migrate/99d69aebc0b89624974cd570d0ed993e.png)
If the value is a number, as in cell B3, the T function result is an empty string. If you use ISTEXT instead, the result is FALSE.
如果值是数字,如单元格B3中一样,则T函数结果为空字符串。 如果改用ISTEXT,则结果为FALSE。
For error values, the T function result is an error, and ISTEXT returns false.
对于错误值,T函数结果为错误,并且ISTEXT返回false。
![T02 T02](https://i-blog.csdnimg.cn/blog_migrate/623ba422f885853e9bd2d5575b157e8f.png)
下载T功能文件 (Download the T Function File)
To see the formulas used in today's examples, you can download the T function sample workbook. The file is zipped, and is in Excel 2007 file format.
要查看当前示例中使用的公式,可以下载T函数示例工作簿 。 该文件已压缩,并且为Excel 2007文件格式。
无T功能视频 (No T Function Video)
With only one small example, there's not enough information to make a demo video for the T function, so class is dismissed early today! _____________
仅举一个小例子,由于没有足够的信息来制作T功能的演示视频,因此今天早些时候开课了! ______________
翻译自: https://contexturesblog.com/archives/2011/01/15/30-excel-functions-in-30-days-14-t/
excel函数:汉字转全拼