Update a named range in excel (and all references to it)?

Update a named range in excel (and all references to it)?

I used a period (.) in all my range names, which is fine for excel but not
fine when I try to export to a google spreadsheet.
Is there an easy way to update all my range names (replace . with _ )?
Copy&replace only handles the references and not the names themselves.
Or, in this case, another solution would be to replace name references
with their normal table location (C5 etc..), the reverse of apply names.
Is there a quick way to do that?