View original (French)

Excel, insert values into a sentence

Solved
Guillaume -  
 MAHDI -
Hello everyone,

In an Excel file, I got values (in B3 and C3 for example) and I would like to insert them into an explanatory sentence, like: "We get B3 successes out of C3 repetitions."
I would like the values of B3 and C3 to appear in this sentence.
Thank you :)

5 answers

  1.
    Denis.L Posted messages 438 Status Member 232
     


    ="We obtain "&B3&" success among "&C3&" repetitions"

    Denis
    25
    1. MAHDI
       
      Thank you.
      0
  2. diddouline
     
    Hello,

    When I use the formula, it inserts the content without its format. That is to say, I inserted a date, but it displays it as a number. How can I fix this?
    8
  3. pilas31 Posted messages 1878 Status Contributor 648
     
    Hello,

    You need to build a formula by concatenation for example:

    ="We get " & B3 & " successes out of " & C3 & " trials"

    Best regards,
    2
  4. Guillaume
     
    Thank you both, that's right!
    Have a good day.
    0