Assigning value based on criteria in Formula

H

Hile

I have a column that contains one of two types of values:
"(Name)Name"
"(Number)Name"

On another column I want to assign a tag to it "Manual" or "Auto". If the
cell starts with "(Name)..." I want it to say Auto else Manual. The
parenthesis is part of the value in the cell and I don't want to have to trim
or do any manual manipulation. I tried using the "T" function but it doesn't
work and I can't figure out the correct syntax using a wildcard to tell it if
the value starts with "(" and "text" assign Auto OR if the value starts with
"(" and "number" assign Manual.

Any suggestions?
 
T

T. Valko

Assuming *all* entries are in this format:

(Biff)Name
(1)Name

=IF(AND(LEFT(A1)="(",ISNUMBER(--MID(A1,2,1))),"Manual","Auto")
 
H

Hile

Thank you so much. You know I know all those darn functions too, I guess
today is not a "thinking" day for me... duh!

:)
 
Top