View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Arrays/Names in spreadsheet.

No there isn't, but you don't need the underscores, you could always use
NewYorkCity, the capitalisation differentiates nicely IMO.

There must be a reason why you want this, are you trying to construct the
names via some coding technique? If so, you should always just replace the
spaces with whichever replacement character you choose.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Dan" wrote in message
...
Hello,
I have a question in regards w/ Defining names/arrays in excel
spreadsheets.
I need to define arrays that consist of more than 1 word, i.e for example
"New York City" and of course Excel doesn't allow to this. The way it
would
be ok w/ Excel such as "New_York_City". My question is: is there any way I
can write the way I need, i.e. I don't need to have lowes spacebar
included.

Thanks.
Dan.