View original (French)

Excel 2013 - the Char() function is not working

Solved
kikou93 Posted messages 438 Status Member -  
kikou93 Posted messages 438 Status Member -
Hello/Good evening,

I'm seeking your help for the following problem:

For example, if we want to write a text like this: (I am a "engineer" in .... etc)

To display the text: = "I am a " & CHAR(24) & " in .... etc" 

CHAR(24)
is used to display the quotation marks

But instead, the following error appears: #NAME?

The function CHAR() is not available in the list of functions

If anyone has a solution to this problem

Thank you in advance for your help
--
How it works is cool!
      1000 Thank you friends

2 answers

  1.
    M-12 Posted messages 1349 Status Member 285
     
    Hello,

    In Excel, it's not CHAR(), but CAR()
    and the quotation marks are not 24, but 34 

    ="I am a " & CAR(34) & "engineer"& CAR(34) & " in .... etc"
    1
    1. kikou93 Posted messages 438 Status Member 1
       
      Hello M-12,

      Strange because I saw a video on YouTube and he used the CHAR() function, it was on Excel 2013

      Here is the video: https://www.youtube.com/watch?v=yPjp8JM5CJo

      For the 24, it’s true, it’s 34, I made a typing mistake

      Thank you for your help
      0
  2. M-12 Posted messages 1349 Status Member 285
     
    Re,

    If you speak English and your Excel is also in English, no problem

    but in French CAR for Caractère

    and in English CHAR for Characters
    0
    1. kikou93 Posted messages 438 Status Member 1
       
      Re,

      Sorry, I didn't take the language difference into account

      Thank you again for your help
      0