chris-evans
Board Regular
- Joined
- Feb 19, 2002
- Messages
- 73
Hi all
I have a formula that pulls through a text string and puts '(1)' at the end of it. I want to format the (1) as superscript. If I had typed just text into a cell this is simple to do, but as this is a formula you cannot format a part of the text string just by selecting format cells. The formula I am using is as follows:
=Prior_Period&" (1)"
Is it possible to use the following? If so how can I format as superscript!?
=Prior_Period & Text(" (1)",[format as superscript])
Any help or thoughts would be appreciated.
Thanks
Chris
I have a formula that pulls through a text string and puts '(1)' at the end of it. I want to format the (1) as superscript. If I had typed just text into a cell this is simple to do, but as this is a formula you cannot format a part of the text string just by selecting format cells. The formula I am using is as follows:
=Prior_Period&" (1)"
Is it possible to use the following? If so how can I format as superscript!?
=Prior_Period & Text(" (1)",[format as superscript])
Any help or thoughts would be appreciated.
Thanks
Chris