How do I merge two cells without deleting data from the cell?

[Joe]

Are there any characters that can be added between the &" and the "& so that
the combined cells can appear as a list instead of a line? For instance, I
have two sentences in two different cells. I want to put in one cell, but
have one above the other with spacing in between.

 

[Paul]

You can use:

=A1&CHAR(10)&B1

Be sure to format the cell as having wrapped text, otherwise you'l
just see a small symbol between the values from A1 and B1.

 

[Stephie]

This worked perfectly, however, I now need to put a comma between the two
names - i.e. currently I have Smith John in one cell, and need Smith, John in
one cell. Is there a way to do that?

 

[Don Guillett]

When all else fails, think about it....

 

[Dave Peterson]

As long as your original data is still there, you can use another formula:

=A1&", "&B1

If all you have is the cell with the result, you could use:

=substitute(a1," ",", ")

 

[Jess12]

That works except now i have a lot of spaces between the information. How
would you get rid of those spaces

 

[Bob I]

Then use this instead.

=A1&B1

That works except now i have a lot of spaces between the information. How
would you get rid of those spaces

:

 

[GonzaloRC]

Hi Gord,
Is there a way I can specify so that the function will:
a) change the results from target cell to next door neighboring cell as values
b) Separate out each string as a line within the same cell, as if I had used
the alt+Enter option myself?

Thanks,

 

[Gord Dibben]

2. Change the de-limiter from " " or "," to Chr(10) and set the cell to
wrap text.

If Len(Cell.Text) > 0 Then sbuf = sbuf & Cell.Text & Chr(10)

1. The function cannot copy anything to anywhere.

Functions return results to the cell in which they are written.

You can manually Copy and paste special>values to next door cell.


Gord

 

[GonzaloRC]

Thanks Gord...

2. Change the de-limiter from " " or "," to Chr(10) and set the cell to
wrap text.

If Len(Cell.Text) > 0 Then sbuf = sbuf & Cell.Text & Chr(10)

1. The function cannot copy anything to anywhere.

Functions return results to the cell in which they are written.

You can manually Copy and paste special>values to next door cell.


Gord



.