Forum Discussion
Complex Cell Format, Maybe!!!
Hi everyone.
Thanks for the assistance so far.
The superscript is becoming something of a need for me, and right now I'm trying to use it to distinguish between two products in a dropdown.
Here are the products:
- Contact Lens Tp,
- Contact Lens Rx.
Tp: Therapeutic, and
Rx: Prescription.
I can get this into the cell, but in the dropdown, it no longer appears as a superscript when I select it. I'm trying to make this work so that I can create a database and use it as a guide for bulk ordering from a preferred manufacturer.
I'd appreciate a constructive insight into this.
Thank you.
Just a thought for the final output: use your Excel data as the source, but send that data through the MailMerge process into Word, where the superscript and subscript could readily be used.
Thank you for your constructive feedback, but I'm not exporting it to MS Word; I'm retaining the information in Excel.
Thanks.
You misunderstand the Mail Merge process. I never had in mind exporting or removing the data from Excel. That's not how mail merge works. On the contrary, this sounds like one of the times when you take advantage of Excel for managing the data, and Word for formatting. In fact, Word gives a lot of flexibility for formatting a nice report that isn't bound to rows and columns.
That doesn't mean you should do it, but if you're going to reject it, reject it for a valid reason.