CODEWITHSUNDEEP
excelexcel-formulaexcel-2010
Simple Poodle
Simple Poodle

Reputation: 7

Excel help: How to add texts/cells together

Usually I do this Excel and it works fine:

= A1 & " example word"

However, when I do this, it doesn't work:

= A1 & " B1 example word"

So I was wondering if anyone got a solution to this problem?

Thank you.

Upvotes: 0

Views: 54

Answers (2)

Nick is tired
Nick is tired

Reputation: 7055

You could also use the CONCATENATE function:

=CONCATENATE(A1, " ", B1, " example word")

Upvotes: 0

Scott Craner
Scott Craner

Reputation: 152505

You need to move any cell references outside the "" and concatenate them with &:

=A1 & " " & B1 & " example word"

Upvotes: 2

Related Questions