Desktop

Ask something
Discussion Locked

Excel - Merge multiple cells into 1 cell

0 helpful
4 replies

by arjterry

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
How does one go about getting mutltiple cells of text to be merged into one cell, even if the information is from a WORD table. Can we merge this way? And How?

4 replies

by tbragsda

You can use the Concatenate function

Cell A1 =CONCATENATE(B1,C1)
Cell B1 Hello
Cell C1 World

Resulting contents of A1 HelloWorld

You can also use;
Cell A1= B1&" "&C1

Resulting contents of A1 Hello World

If you need the results to be converted to text rather than the results of the function, use cut/paste special+Values

by abrouss

you can also add additional info that is not listed in the current cells

as stated in the previous message

use the concatenate fucntion

example
Al Artist
B1 Title

and you want to have in C1 Artist, Title
to add the comma or other infouse this example
in C1 type
=concatenate(A1,", ",B1)

this wil give you Artist, Title
You can put spaces after the comma just be sure to use the "" around what ever you want to add in

The info in C1 is now a formula so now you can copy the info in C1 and paste it another cell using the "paste special" option and paste "value"
this will give you the info in a text format.

This discussion is closed to new replies.