K
kevinpiwa
I am trying to make a "program" that allows someone to enter data in one
worksheet through data validations and data entry, and then through the use
of a lot of formulas, a data plate is created on another sheet. One of my
data validations is company names which require the (R) symbol as a
subscript. The data plate worksheet requires a formula to retrieve the
correct company name from the data entry worksheet. I know you can't use
subscripts in formulas, and I don't really know anything about Macros or
writing code. Is there a way to make all registered trademark symbols in a
worksheet appear as subscripts, regardless of the format? Also, I can't have
the (R) sitting in an adjacent column as a subscript because the company name
has to be centered in a group of merged cells. Thanks
worksheet through data validations and data entry, and then through the use
of a lot of formulas, a data plate is created on another sheet. One of my
data validations is company names which require the (R) symbol as a
subscript. The data plate worksheet requires a formula to retrieve the
correct company name from the data entry worksheet. I know you can't use
subscripts in formulas, and I don't really know anything about Macros or
writing code. Is there a way to make all registered trademark symbols in a
worksheet appear as subscripts, regardless of the format? Also, I can't have
the (R) sitting in an adjacent column as a subscript because the company name
has to be centered in a group of merged cells. Thanks