Assigning value based on criteria in Formula
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
|