Logo 
Search:

MS Office Answers

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Thomas Evans   on Jan 23 In MS Office Category.

'Recognise' a specific numerical format and act accordingly


  
Question Answered By: Corey Jones   on Jan 23

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: