View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
andreashermle andreashermle is offline
external usenet poster
 
Posts: 123
Default Change synthax of workbook-level names in one go

Dear Experts:

A workbook with several worksheets has numerous workbook-level names,
which all have the following synthax:

_##_###_##_## (e.g. _90_237_44_44)

I would like to run a macro that changes all the above workbook-level
names to the following synthax:

##-###-##-## (e.g. 90-237-44-44). That is the first underscore has to
be dropped, all the other underscores have to be replaced with
hyphens.

Help is much appreciated. Thank you very muc in advance.

Regards, Andreas