Mixed Text & Numbers
=IF(LEFT(A2)="*",--RIGHT(A2,LEN(A2)-1),A2)
--
David Biddulph
"Mike" wrote in message
...
I have a row of numbers, which can be 2 or 3 digits long. Some have *
before
the numbers, some don't. I want another cell to be able to read the
numeric
value if the cell has an * before it. Any ideas? I'm stuck.
|