Combine Text Cells

L

lightbulb

Is there a formula to combine the text in multiple cells into one cell? I.E.
if Cell A1 says RNA and Cell B1 says Te4 and Cell C1 says Late, is there a
way to make Cell D1 combine them and be "RNA Te4 Late"?

Thanks!
 
J

John C

You can use Concatenate, or just a regular formula:
=CONCATENATE(A1," ",B1," ",C1)
=A1&" "&B1&" "&C1
 
M

M Kan

=A1&" "&B1&" "&C1

The " " just adds a space in between the words.

You could also use =Concatenate(A1,B1,C1) if you don't need the spaces
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining Text From Cells 3
Combining a string of text 3
Date converts to number when part of a formula 3
Hope this is easy 3
Merging three cells into one 3
Combining cells 2
Combining cells with separater 6
Combine cells with the same reference and combine quantities 2

Top