Extract number from a cell and conditionally enter text

[Tympos]

Hello,

This is an exmpale of column B values assuming they start from fisrt row:
1
2
3
T1
4
DAT1
DAT2
T2
5
6
etc

What I am trying to do is this:
Column B is filled with either a)only numbers b)a specific letter, letter T always, and numbers e.g. T345 c) three specific letters, always letters DAT and numbers e.g. DAT9741. There are no other types of entered values.
I would like to enter the number of row in cell A1 of the corresponding value and make excel return only the number value of the cell.
For example
1. If I input value 4 the cell data will be T1, and I want to extract number 1.
2. If I input value 9 the cell data is 5, and I want to extract the number itself, number 5.
3. If I input value 6 the cell data is DAT1, and I want to extract the number 1.

Also I wouls like to make excel write something on a cell depending if the previous selected cell is a number, starts with T, or starts with DAT.
For example
1. If I enter number 4 I would like in cell J12 write the sentence "Invoice" because cell B4 starts with T"Receipt",
2. If I enter number 9 I would like in cell J12 write the sentence "Receipt" because cell B9 is ONLY number, and
3. If I enter number 6 I would like in cell J12 write the sentence "Purchase" because cell B6 starts with DAT

I hope I made it clear...

Thank you for any help!!!

[TMS]

Try:

Please Login or Register  to view this content.

[TMS]

Use LEFT to extract 1 or 3 characters and test for T and DAT respectively. Nest the IF statements.