| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom Formating Letters to Numbers while Displaying Letters | Excel Worksheet Functions | |||
| formula to work in a 3-d reference with 2 work books | Excel Worksheet Functions | |||
| How do change a column of data in capitol letters to small letters | Excel Discussion (Misc queries) | |||
| formula with letters and numbers | New Users to Excel | |||
| MAX formula for alphabetical letters | Excel Discussion (Misc queries) | |||
Linear Mode
