Assigning value based on criteria in Formula
Assuming *all* entries are in this format:
(Biff)Name
(1)Name
=IF(AND(LEFT(A1)="(",ISNUMBER(--MID(A1,2,1))),"Manual","Auto")
--
Biff
Microsoft Excel MVP
"Hile" wrote in message
...
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?
--
Hile
|