Excel, insert values into a sentence
Solved
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 :)
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
-
="We obtain "&B3&" success among "&C3&" repetitions"
Denis -
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? -
ContributorHello,
You need to build a formula by concatenation for example:
="We get " & B3 & " successes out of " & C3 & " trials"
Best regards, -
Thank you both, that's right!
Have a good day. -
Thank you
