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!!!
Bookmarks