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

No.

Just use (R) in the same line as the company.

And avoid merged cells at all costs.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"kevinpiwa" wrote:

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