FORMULA WON'T WORK WITH LETTERS

[Guest]

I have this formula

=IF(LEN(TA!D2)>6,--RIGHT(TA!D2,6),TA!D2)

and it will take the last 6 numbers of a receipt from work book TA, line D2
and leave only the last six digits.

That is it will take 1234654318983

and leave 318983

It will only work with numbers. I have some receipts that have letters as
the last characters in the sequence.

How can I get the formula to work with letters as well as numbers?

 

[Don Guillett]

try leaving out the --

 

[Bob Phillips]

=IF(LEN(TA!D2)>6,IF(ISNUMBER(TA!D2),--RIGHT(TA!D2,6),RIGHT(TA!D2,6)),TA!D2)

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

 

[halimnurikhwan]

Hi,
Try this one, it may be help you ...:
=IF(LEN(TA!D2)>6,RIGHT(TA!D2,6),TA!D2)

Rgds,

Halim

 

[Guest]

Thank you all,

The formula's worked perfectly (all of the formula's submitted).