Change Multiple Defined Names

[Veeatch]

Hi Guys,
I have a heap of Defined names, a few hundred actually that I want to change how they are currently named,
I have done all of these manually over a long period of time, and now I want to clean things up so it is easier to find what I need.
i was hoping there was a quick way to change these (VBA code perhaps) names so that the number (xx.xx) comes first, as they are currently last as outlined below.

xx.xx is currently from 01.01 to 80.09, so that's a lot to change manually.
any help with this would be awesome.

BOQ_Title_xx.xx
BOQ_SQM_xx.xx
BOQ_SQMRate_xx.xx
BOQ_PCTotal_xx.xx
BOQ_PSTotal_xx.xx
BOQ_Markup_xx.xx
BOQ_ScopeSQM_xx.xx
BOQ_ScopeTrue_xx.xx
BOQ_CTotal_xx.xx
BOQ_Profit_xx.xx
BOQ_STotal_xx.xx
BOQ_GST_xx.xx
BOQ_GTotal_xx.xx
BOQ_Scope_xx.xx

they should look like this, so I can quickly find a section by number.
xx.xx_BOQ_Title
xx.xx_BOQ_SQM
xx.xx_BOQ_SQMRate
xx.xx_BOQ_PCTotal
xx.xx_BOQ_PSTotal
xx.xx_BOQ_Markup
xx.xx_BOQ_ScopeSQM
xx.xx_BOQ_ScopeTrue
xx.xx_BOQ_CTotal
xx.xx_BOQ_Profit
xx.xx_BOQ_STotal
xx.xx_BOQ_GST
xx.xx_BOQ_GTotal
xx.xx_BOQ_Scope

thanks guys.

 

[Micron]

What do you mean by "find a section by number"? You can easily extract the number portion of the name:
mid("BOQ_Scope_xx.xx",Instrrev("BOQ_Scope_xx.xx","_")+1) which returns xx.xx

I think transposing the numeric portion will be tricky, although probably doable, but maybe you don't have to? I think it depends on whether you have a list of Defined Names or not (or could make one with a debug.print list). If not and you intend to loop over all the Defined Names, when using vba they can look like
Sheet8!Criteria, or
EditableRange
so that may be an issue.