Arrays/Names in spreadsheet.
 

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.

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.