View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Calanbraun Calanbraun is offline
external usenet poster
 
Posts: 1
Default Name Ranges: Function to convert special characters underscores

I created a named range using the name: Overall Segment Size - Street $(M)

Excel automatically converts the name to get rid of special characters and
spaces to: Overall_Segment_Size___Street___M

The question is: Is there a function which allows me to convert the names
to this format before naming the range?

Please help!