| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
concatenate and then take off last #
What can I add to the following formula so that it will take off the last
digit? Because it will always have that zero on the end that I don't want. Thanks! As in: A6: 020605006AA20 =CONCATENATE("", RIGHT(A6,8)) -- Nicki Taylor |
Threaded Mode
