Create special symbols

[FryGirl]

I would like to create some named ranges using the list below. x with a subscript number. If I manually create a named range, with x1, it comes out as x1_.

Is there any way to create a named range without the underscore almost like a symbol? Does this need to be done in VBA making symbols of everything in column A or is there a font like wingdings that would have this symbol and would translate as a named range without the underscore?

After the x with a subscript number, I would like to create b with a subscript number

My goal, instead of a formula like 345.67 + .0012(32.1), I would like to use the named ranges so it is a + b1(x1)

Book1
	A	B
1	x1	b1
2	x2	b2
3	x3	b3
4	x4	b4
5	x5	b5
6	x6	b6
7	x7	b7
8	x8	b8
9	x9	b9
10	x10	b10
Sheet1

 

[Yongle]

These 2 links should help:

Illegal Range Names – Daily Dose of Excel

What Are the Rules for Excel Names? - Contextures Blog

As Juliet famously said to Romeo, "What's in a name?" And she was talking about rows (misspelled as "rose"), so maybe Juliet was using a spreadsheet at the

contexturesblog.com

 

[mikerickson]

A named range references cells, not their content and not the formatting of those cells.

If you want rich text (like a normal x with a subscript 1), you'd have to avoid formulas all together, including those that use named ranges.

 

[FryGirl]

Hi and thank you for the help.

@Yongle, I looked at those links, but nothing looked like what I'm asking, but of course, I could be missing the golden nugget.

@Mike, here is what I'm thinking. See in cell D10 and I10 the named ranges have the underscore because they are too much like a cell reference. I used Ctrl + Shift + F3 to create named ranges from cells A7:C8 and F7:H8. So, instead of D4 and I4, I would like D11 and I 11.

BTW, this is not a show stopper, just something I thought I would ask if possible. (the subscript does not show up too well with the XL2BB)

Book1
	A	B	C	D	E	F	G	H	I
1	a	x1	b1			a	b2	x2
2	234.23	7	0.7370			234.23	0.6393	5
3
4			239.389	=A2+(C2*B2)				237.426	=F2+(H2*G2)
5
6
7	a	x1	b1			a	b2	x2
8	234.23	7	0.7370			234.23	0.6393	5
9
10			239.389	=a+(b1_*x1_)				237.426	=a+(b2_*x2_)
11				=a+(b1*x1)					=a+(b2*x2)
Sheet1

 

[FryGirl]

I found a solution that works for me. I placed an x in the cell and then inserted a symbol. Normal text, superscripts and subscripts. Again, this works fine. Thank you for your time.