Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Name Ranges: Function to convert special characters underscores
yo u cant use anything which excel can interpret as a cell reference ie $M
Guidelines for names What characters are allowed? The first character of a name must be a letter, an underscore character (_), or a backslash (\). Remaining characters in the name can be letters, numbers, periods, and underscore characters. Can names be cell references? Names cannot be the same as a cell reference, such as Z$100 or R1C1. Can more than one word be used? Yes, but spaces are not allowed. Underscore characters and periods may be used as word separators €” for example, Sales_Tax or First.Quarter. How many characters can be used? A name can contain up to 255 characters. Note If a name defined for a range contains more than 253 characters, you cannot select it from the Name box. Are names case sensitive? Names can contain uppercase and lowercase letters. Microsoft Excel does not distinguish between uppercase and lowercase characters in names. For example, if you have created the name Sales and then create another name called SALES in the same workbook, the second name will replace the first one. -- paul remove nospam for email addy! "Calanbraun" wrote: 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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Name Ranges: Function to convert special characters underscores
Hi Calanbraun,
The following should do the job : =SUBSTITUTE(A1,"_","") HTH Cheers Carim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Convert Figures into Text in Excel | Excel Worksheet Functions | |||
How can you use multiple ranges in a function? | Excel Worksheet Functions | |||
convert numbers to text | Excel Discussion (Misc queries) | |||
Function To Convert Liters To Imperial Gallons & Vice Versa | Excel Worksheet Functions | |||
How do I use Excel's convert function for apothecary weight? | Excel Worksheet Functions |