| Home |
| Search |
| Today's Posts |
|
#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 |
| 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) | |||
Threaded Mode
