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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
concatenate and then take off last #
Hi
Try =CONCATENATE("", MID(A6,6,7) Regards Roger Govier NTaylor wrote: 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)) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
concatenate and then take off last #
=mid("a6",1,len("A6")-1) - - Mark "NTaylor" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
concatenate and then take off last #
Thanks... the following worked (just slightly diff from yours)... THanks!
=CONCATENATE("",MID(A6,9,8)) -- Nicki Taylor "Roger Govier" wrote: Hi Try =CONCATENATE("", MID(A6,6,7) Regards Roger Govier NTaylor wrote: 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)) |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
concatenate and then take off last #
=left(a6,len(a6)-1)
You don't need to concatenate to force it to be a string. =Left() will return a string. NTaylor wrote: 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 -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
concatenate and then take off last #
if you use this formula =CONCATENATE("",MID(A6,9,8)) then I hope the length of the numbers is always 9 ......!!!! "NTaylor" wrote: Thanks... the following worked (just slightly diff from yours)... THanks! =CONCATENATE("",MID(A6,9,8)) -- Nicki Taylor "Roger Govier" wrote: Hi Try =CONCATENATE("", MID(A6,6,7) Regards Roger Govier NTaylor wrote: 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)) |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
concatenate and then take off last #
Hi Nicki
From your original example, I assumed you wanted 5066AA2 out of the value in A6, which is what I was trying to achieve. I also assumed that all of your data was of the same format. Your solution, must be referring to a much longer string in A6 for it to work. As pointed out by Excelforeman, the more generalised way would be to look at the length of the string, and the formula should be (I think, if my interpretation of what you want is correct), as follows =CONCATENATE("",MID(A6,LEN(A6)-8,7)) or as Dave rightly points out, you don't need the concatenation so =MID(A6,LEN(A6)-8,7) Regards Roger Govier Roger Govier wrote: Hi Try =CONCATENATE("", MID(A6,6,7) Regards Roger Govier NTaylor wrote: 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)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|