Put spaces in the name manager

[pedrofilipegomes]

Hello,

I want to put spaces in names manager..i have several brand names with spaces such as : NEW BALANCE UNDER ARMOUR , ETC. and I want to put these names in the name manager so that you can call them in another cell through indirect function.

Anyone can help me plz?

Thank's

[udprocks]

Space are not allowed in Name manager title.

[pedrofilipegomes]

And there is no way to put spaces in a name? It is that if there is I can not use indirect function names that have space

[udprocks]

And there is no way to put spaces in a name? It is that if there is I can not use indirect function names that have space

i think no,

please go through the below link for more informatiopn about "Name Manager"

[Sam Capricci]

Would NEW_ BALANCE_UNDER_ARMOUR work for you?

[pedrofilipegomes]

Would NEW_ BALANCE_UNDER_ARMOUR work for you?

No

I need the words with spaces , the character " _ " can not replace the space.

[Norie]

Why do you 'need' spaces in the name(s)?

[pedrofilipegomes]

Why do you 'need' spaces in the name(s)?

Because my names has spaces and i need to call them with indirect function.

[Norie]

You can easily replace the spaces with underscores in your INDIRECT formula.

For example, lets say you have MY RANGE in A1 and you want to sum a named range called MY_RANGE.

Then you could use this formula.

Please Login or Register  to view this content.

[PosseJohn]

If you're needing to keep the spaces in the cell, could you add another column duplicating the names (but without spaces)?

Are you familiar with VBA? This can easily be addressed by use of some simple code.

ActiveWorkbook.Names.Add Name:=Replace(Range("C3").Value, " ", ""), RefersTo:="=Sheet1!C3", Visible:=True

[pedrofilipegomes]

You can easily replace the spaces with underscores in your INDIRECT formula.

For example, lets say you have MY RANGE in A1 and you want to sum a named range called MY_RANGE.

Then you could use this formula.

Please Login or Register  to view this content.

Thank's but this formula don't solve my problem.

[pedrofilipegomes]

If you're needing to keep the spaces in the cell, could you add another column duplicating the names (but without spaces)?

Are you familiar with VBA? This can easily be addressed by use of some simple code.

ActiveWorkbook.Names.Add Name:=Replace(Range("C3").Value, " ", ""), RefersTo:="=Sheet1!C3", Visible:=True

Yes, i can add another column duplicating the names.

Yes, i work with VBA..Can you help me?

[Norie]

What I posted is just an example.

Without knowing what your problem actually is it's hard to give specific advice.

[pedrofilipegomes]

What I posted is just an example.

Without knowing what your problem actually is it's hard to give specific advice.

I explain what I want

I have names of brands in column A of sheet 2: NEW BALANCE; UNDER ARMOUR; NIKE; ADIDAS

In the column B of sheet 2 I have technologies associated with brands of column sheet 2: {NB Dry; NB ICE}; UNDER ARMOUR = {ColdBlack, Moisture transport System}; NIKE ={Dry-FIT; ACC; Nike Skin} and ADIDAS={ClimaLite, ClimaCool, Boost}.


And I want to give the brand names of these sets of technologies, for example: NEW BALANCE={NB Dry; NB ICE}; {ColdBlack, Moisture transport System}; {Dry-FIT; ACC; Nike Skin} and {ClimaLite, ClimaCool, Boost}.

In column A of sheet1 i used indirect function to call the brands that are in column A of sheet 2.

In column B of sheet 1 i want to call I WANT call the technology associated with brand chosen in column A of sheet 1..For brands that do not have space in the name ( Nike and Adidas ) , I can . But for others who have space can not

[Norie]

Are you using data validation?

[pedrofilipegomes]

Are you using data validation?

Yes, I'm using

[Norie]

OK, I'll mock something up and post/attach it later - not at computer right now.