Arrays/Names in spreadsheet.

[Dan]

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.

 

[Bob Phillips]

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)