Looks for "sed" as functionality in Excel

I am using excel for structuring state machines. Therefore, I often format cells so that I can directly cut and project entire sections into the source code.

Currently I need to preprocess one of my code blocks so that I can replace "-" with "_" in my IDs. For example, in a cell, I could

#define Some-preprocessor-name

      

        
        
        
      

    

But I would like:

#define SOME_PREPROCESSOR_NAME

      

        
        
        
      

    

The upper case bit is covered by UPPER (), but the hyphenation is arbitrary, as is the number I expect to find. suggestions