+ Reply to Thread
Results 1 to 3 of 3

Superscript as part of Concatenate Formuale

  1. 08-04-2010, 12:18 PM #1
    ernestgoh
    ernestgoh is offline
    Registered User
    Join Date
    07-02-2005
    Posts
    53

    Superscript as part of Concatenate Formuale

    Hi, is it possible to superscript "1 2" in red?

    =CONCATENATE("7% GST of "&TEXT(G41+G45,"$0,00.00"&"1 2"))

    TIA!
    Last edited by ernestgoh; 08-04-2010 at 12:39 PM.
    Reply With QuoteRegister To Reply
  2. 08-04-2010, 12:32 PM #2
    Coaster
    Coaster is offline
    Forum Contributor
    Join Date
    10-11-2008
    Location
    Portugal
    MS-Off Ver
    Excel 2010
    Posts
    111

    Re: Superscript as part of Concatenate Formuale

    try:

    =CONCATENATE("7% GST of "&TEXT(G41+G45,"$0,00.00"&char(185)&" "&char(178)))
    Reply With QuoteRegister To Reply
  3. 08-04-2010, 12:39 PM #3
    ernestgoh
    ernestgoh is offline
    Registered User
    Join Date
    07-02-2005
    Posts
    53

    Re: Superscript as part of Concatenate Formuale

    Quote Originally Posted by Coaster View Post
    try:

    =CONCATENATE("7% GST of "&TEXT(G41+G45,"$0,00.00"&char(185)&" "&char(178)))
    works like a treat! thanks coaster.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1