Logo 
Search:

MS Office Answers

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Deepu Ramani   on Dec 08 In MS Office Category.

'Recognise' a specific numerical format and act accordingly


  
Question Answered By: Reamonn Fischer   on Dec 08

The sample code should work and you can refine it by changing



If IsNumeric(TmpStr) And Len(TmpStr) > 2 Then



To



If IsNumeric(TmpStr) And Len(Words(0)) = 9 Then



The first one just looks for a numeric string with more than two numbers.
The new line will look for a numeric string that has nine characters
(including optional dashes)

Share: 

 

This Question has 17 more answer(s). View Complete Question Thread

 


Tagged: