View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dingo[_2_] Dingo[_2_] is offline
external usenet poster
 
Posts: 1
Default VBA - Looking to strip alphanumeric from numeric

Hi,

I am trying to write a VBA macro that given an input of, say
"AS9F89A779FA87" will give an output of "98977987". The macro I want t
write would analyze a given input with mixed alphanumeric and numeri
characters, and remove the alphanumeric from the numeric.

But I'm stuck....help please

--
Message posted from http://www.ExcelForum.com