| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
first 0
Hi all ihave a column of numbers like
00022230013A 00111110007A 00044440132A and I need to find the first 0 from the right in each number, can anyone please help. Ta. -- delmac |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
first 0
Do you mean find its position in the string?
=FIND("~",SUBSTITUTE(A1,"0","~",LEN(A1)-LEN(SUBSTITUTE(A1,"0","")))) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "delmac" wrote in message ... Hi all ihave a column of numbers like 00022230013A 00111110007A 00044440132A and I need to find the first 0 from the right in each number, can anyone please help. Ta. -- delmac |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
first 0
=FIND("#",SUBSTITUTE(A1,0,"#",LEN(A1)-LEN(SUBSTITUTE(A1,0,""))))
-- Kind regards, Niek Otten Microsoft MVP - Excel "delmac" wrote in message ... | Hi all ihave a column of numbers like | 00022230013A | 00111110007A | 00044440132A and I need to find the first 0 from the right in each number, | can anyone please help. Ta. | -- | delmac |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
first 0
to find the position using VB:
Dim iPos As Long Dim MyString As String iPos = InStrRev(MyString, "0") "delmac" wrote: Hi all ihave a column of numbers like 00022230013A 00111110007A 00044440132A and I need to find the first 0 from the right in each number, can anyone please help. Ta. -- delmac |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
first 0
tried this and got nothing Charlie, thanks though.
-- delmac "Charlie" wrote: to find the position using VB: Dim iPos As Long Dim MyString As String iPos = InStrRev(MyString, "0") "delmac" wrote: Hi all ihave a column of numbers like 00022230013A 00111110007A 00044440132A and I need to find the first 0 from the right in each number, can anyone please help. Ta. -- delmac |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
