Since you didn't give a whole lot of information, try this for the info you
did give:
=IF(ISERR(--LEFT(A1,3)),RIGHT(A1,LEN(A1)-3),A1)
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"TimE" wrote in message
...
I would like to check if the first three characters are alpha, if so,
remove them. The alpha characters will be any combination.
EX.
BEFORE - ABC123
RESULT - 123
The alpha will not be the same or I would use:
=IF(LEFT(A1,3)="ABC",RIGHT(A1,LEN(A1)-3))
Thanks in advance for ANY assistance.
--
TimE
------------------------------------------------------------------------
TimE's Profile:
http://www.excelforum.com/member.php...fo&userid=2139
View this thread: http://www.excelforum.com/showthread...hreadid=483637