+ Reply to Thread
Results 1 to 7 of 7

Unicode Characters in formula's

Hybrid View

  1. #1
    Registered User
    Join Date
    09-30-2013
    Location
    england
    MS-Off Ver
    Excel 2020
    Posts
    58

    Unicode Characters in formula's

    Hello

    how do i add a unicode formula into a formula?

    See attached example.

    Thanks...
    Attached Files Attached Files

  2. #2
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,278

    Re: Unicode Characters in formula's

    Try with
    Formula: copy to clipboard
    ="Degrees 2300"&" "&CONCATENATE(C3,"x",D3," ",F3,"   ","(",I3," Kg/m)  ",G3,"Lg")


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  3. #3
    Registered User
    Join Date
    09-30-2013
    Location
    england
    MS-Off Ver
    Excel 2020
    Posts
    58

    Re: Unicode Characters in formula's

    Hello

    it does not work.

  4. #4
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Unicode Characters in formula's

    You mean something like this: =CONCATENATE(C3&CHAR(176),"x",D3," ",F3," ","(",I3," Kg/m) ",G3,"Lg") ?

  5. #5
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,278

    Re: Unicode Characters in formula's

    I have tested, (Excel 2007) its work. Plz refer attach file.
    Attached Files Attached Files

  6. #6
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,786

    Re: Unicode Characters in formula's

    @Avk

    What the Op wanted was Char(176) character as per Sandy's reply.

  7. #7
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,278

    Re: Unicode Characters in formula's

    Oopps, confusion, as per attach file he says front of formula, i imaging as a text required, not mentioing as a symbol.
    Yes i got.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. From Characters To Unicode
    By nshadow1996 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-19-2014, 06:06 PM
  2. Best way to find/replace Unicode characters
    By greek in forum Word Programming / VBA / Macros
    Replies: 4
    Last Post: 03-17-2014, 05:39 PM
  3. [SOLVED] Remove special unicode characters from range
    By Trentos in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-08-2012, 12:23 PM
  4. [SOLVED] Extra characters exported in unicode(.txt) format
    By PT in forum Excel General
    Replies: 0
    Last Post: 02-07-2006, 07:35 AM
  5. show unicode characters in excel 97
    By mowali in forum Excel General
    Replies: 0
    Last Post: 03-09-2005, 01:22 PM
  6. [SOLVED] inserting unicode characters
    By Wazooli in forum Excel General
    Replies: 1
    Last Post: 02-07-2005, 03:06 PM
  7. How do I enter Unicode characters in Excel?
    By MacroAlan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-05-2005, 05:06 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1