Thread: first 0
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Charlie Charlie is offline
external usenet poster
  
Posts: 703
Default 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
Reply With QuoteReply With Quote