Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
In excel how do i get from this 44345678912 to this 0345678912 us.
I have in column A list of numbers looking like this 44345678912 and i need
to place a zero in front of the number but also taking away the two fours, i know the formula for adding the zero ="0" & [A1] but can anyone help with removing the two fours or a quick way to doing one at a time? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
In excel how do i get from this 44345678912 to this 0345678912 us.
Assuming you're always dropping the first 2 digits:
="0"&RIGHT(A1,LEN(A1)-2) If you're speciifcally looking for double 4's: ="0"&SUBSTITUTE(A1,"44","") Do note that both of these result in a text string, not a number. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Twoways" wrote: I have in column A list of numbers looking like this 44345678912 and i need to place a zero in front of the number but also taking away the two fours, i know the formula for adding the zero ="0" & [A1] but can anyone help with removing the two fours or a quick way to doing one at a time? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
In excel how do i get from this 44345678912 to this 0345678912 us.
Formula
="0"&RIGHT(C4,LEN(C4)-2) macro sub fixnums() for each c in range("a2:a22") c.value="0"&"&RIGHT(C,LEN(C)-2) next c end sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Twoways" wrote in message ... I have in column A list of numbers looking like this 44345678912 and i need to place a zero in front of the number but also taking away the two fours, i know the formula for adding the zero ="0" & [A1] but can anyone help with removing the two fours or a quick way to doing one at a time? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|