Fresh Excel Tips

There are times when we have a set of values in a column that we’d like to check if they are in the correct format. The T Function will check if a value in a specified cell is in the text format or not. If it is text, the function will return the text that is in the column and if it is not, the function will not return anything. Here is how we will use it in a formula.

How to check for valid numbers using the T Function

1. Enter your values and text in Column A from A1:A10
2. In Cell B1, Enter the following formula: =T(A1).
3. Use the fill handle to copy the formula to the remaining cells in the column as is necessary

You should now know the valid and invalid numbers in the column. This should work in Excel 97, 2000, 2003 and 2007.

1. Using the OR function to check cells for text or numbers in Excel
2. How to check for invalid values using the TYPE function in Excel
3. How to convert invalid numbers to valid numbers in Excel
4. Identify missing numbers in a consecutive list using Excel
5. How to check for future dates using TODAY Function in Excel