Excel-How do I fill a cell with text with a formula?

Question

Lets say I have the word HELLO in Cell B6, how do I, in cell B7, display with a formula the word in cell B6 without a copy/paste function

Answer 1

"The text I want to display is in the middle of an existing formula …"



You can *concatenate* text to a value or formula result by using the & operator or CONCATENATE() function.



F1: anyway

F2: ="It's " & (TODAY() - 3) & " " & F1 — this will show something like "It's 17-Sep anyway"



Remember to add spaces where needed, and to put all text in a formula between double quotes.

Answer 2

In B7 type =B6

Answer 3

=B6