Thread: do you know how to take out the 011 from this number:011548926 in.
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default do you know how to take out the 011 from this number:011548926 in.
Dim sStr as String
sStr = "011548926 in"
sStr = Application.Substitute(sStr,"011","")
msgbox sStr

--
Regards,
Tom Ogilvy



"reggy" wrote in message
...



Reply With QuoteReply With Quote