FORMULA WON'T WORK WITH LETTERS
 

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?

FORMULA WON'T WORK WITH LETTERS
 

try leaving out the --

--
Don Guillett
SalesAid Software

"OfficeNDN" wrote in message
...
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?

FORMULA WON'T WORK WITH LETTERS
 

=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)

"OfficeNDN" wrote in message
...
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?

FORMULA WON'T WORK WITH LETTERS
 

Hi,

How can I get the formula to work with letters as well as numbers?
Try this one, it may be help you ...:
=IF(LEN(TA!D2)6,RIGHT(TA!D2,6),TA!D2)

Rgds,

Halim

FORMULA WON'T WORK WITH LETTERS
 

Thank you all,

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

" wrote:

Hi,

How can I get the formula to work with letters as well as numbers?
Try this one, it may be help you ...:
=IF(LEN(TA!D2)6,RIGHT(TA!D2,6),TA!D2)

Rgds,

Halim