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

Denis.L Posted messages 438 Status Member 232
 


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

Denis
25
MAHDI
 
Thank you.
0
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
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
Guillaume
 
Thank you both, that's right!
Have a good day.
0
lolo
 
Thank you
0