View Single Post
  #16   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Validation of UK VAT Number

On Sat, 17 Apr 2010 21:04:04 +0100, "Rob"
wrote:

Thanks Ron, another brilliant way to achieve the result.

Ta, Rob


Thanks for the feedback. Of course, it depends on the input being exactly 9
digits, allowing any number of <space's to be interspersed. If the input is
different, then some modification would be required.
--ron