Merge/connect cells without loss of data?

[dakar]

Hi everyone,

stupid question I did not find an answer for even after a long search:

I have an Excel table with cells which contain fax numbers. One cell i
a row contains the dialling code, the next cell in this row contains th
fax number.
For a series-letter I created with Word, these two cells have to b
merged into ONE, so Word can read the fax number including the diallin
code in "one piece".

So, for example, I merge A1 ("040") with B1 ("636465"), the resul
should be A1 ("040636465"). But the standard procedure to merge/connec
cells in Excel only preserves the content of the first cell, so afte
merging A1 and B2, the content of B2 is lost.
What a mess.

How do I merge two cells into one, so that the content of these tw
cells is combined in one cell?

Any ideas and/or solutions greatly appreciated!

Thanks & have a good week

daka

 

[Rehan Akhtar]

use formula CONCATENATE() in excel.. or simply do this
in the cell where you want to add A1 and B1

=A1&B1

this would do the same trick as concatenate..

also if you want to add something in between the values
of two cells.. then
=A1&"KKK"&B1 (KKK is the value that you want to add in
all cells between A1 and B1

cheers..

 

[Guest]

Hi
one way:
in C1 enter
=A1 & B1
and copy this down for all rows

 

[insane]

Is there a way to do this without the formula?

I`m having a bit of a dilemma when i need to copy that number and exce
just copies the formula

 

[insane]

bring up my pos

 

[Frank Kabel]

Hi
for copying use 'Edit - Paste Special - Values'

 

[insane]

Thanx alot (