Combining data from 2 cells into 1 cell

[gbread]

I'm trying to combine the contents of cell D3 with cell H3 and put all the
combined data in cell H34. I tried: =D3&H3 but that didn't work. Do the
cells have to be adjacent to work?

Thanks.

Any suggestions?

 

[Mike H]

Hi,

The formula you posted should work fine and 'that didn't work' isn't a very
helpful description of the problem.

What's in the cells?
What result did you get?
What result did you expect?

Mike

 

[trip_to_tokyo]

Let me give you a brief example based on the information you have given:-

1. In cell D 3 I have:-

smith

2. In cell H 3 I have:-

jones

3. In cell H 34 I have:-

=CONCATENATE(D3,H3)

Cell H 34 shows, when I look at it on the screen in front of me:-

smithjones

This is a very simple example showing you how to add the contents of 2 cells
that contain text.

What Mike says is correct though.

You need to provide more details of the data that your cells contain and
what you are trying to achieve.

If my comments have helped please hit Yes.

Thanks.