How can we find the position of letter in Excel ?

FIND

What Does It Do?

This function looks for a specified letter inside another piece of text.

When the letter is found the position is shown as a number.

If the text contains more than one reference to the letter, the first occurrence is used.

An additional option can be used to start the search at a specific point in the text, thus

enabling the search to find duplicate occurrences of the letter.

If the letter is not found in the text, the result #VALUE is shown.

Syntax

 =FIND(LetterToLookFor,TextToLookInside,StartPosition)

LetterToLookFor : This needs to be a single character.

TextToLookInside : This is the piece of text to be searched through.

StartPosition : This is optional, it specifies at which point in the text the search should begin.

Formatting

No special formatting is needed, the result will be shown as a number.

Check if a cell contains text - Excel

=T()

What Does It Do ?

This function examines an entry to determine whether it is text or not.
If the value is text, then the text is the result of the function
If the value is not text, the result is a blank.
The function is not specifically needed by Excel, but is included for compatibility with
other spreadsheet programs.

How to get TRUE/FALSE result ?

=ISTEXT()

What Does It Do ?

This functions tests an entry to determine whether it is text.

If the entry is text is shows TRUE.

If the entry is any other type it shows FALSE.

Example
The following table was used by a personnel department to lookup the salary of an employee.
The employee can be entered as a Name or as a Numeric value.
The =ISTEXT() function has been used to identify the type of entry made, and then
the =IF() decides which VLOOKUP to perform.