[Megglesface]

I have three colums in excel, column A has a number in it, column B a name
and column C an address.
i want to merge them so that the number, name and address of each person is
in one cell.
when I select the three cells and click merge it brings up an error message
saying that the values in the cells are different and merging will keep only
the info from column A.
anyone know why this is happening or how to get around it?

Thanks

[Mike H]

Hi,

Concatenate them into a third column and Hide the original 3

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

Mike

"Megglesface" wrote:

I have three colums in excel, column A has a number in it, column B a name
and column C an address.
i want to merge them so that the number, name and address of each person is
in one cell.
when I select the three cells and click merge it brings up an error message
saying that the values in the cells are different and merging will keep only
the info from column A.
anyone know why this is happening or how to get around it?

Thanks

[Megglesface]

Ok that great, thanks, I have merged the three columns into one, but the
original three columns are still showing.
When i delete them this obviously deletes the new merged column too.

do you know how to fix this?

Thanks


"Mike H" wrote:

Hi,

Concatenate them into a third column and Hide the original 3

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

Mike

"Megglesface" wrote:

I have three colums in excel, column A has a number in it, column B a name
and column C an address.
i want to merge them so that the number, name and address of each person is
in one cell.
when I select the three cells and click merge it brings up an error message
saying that the values in the cells are different and merging will keep only
the info from column A.
anyone know why this is happening or how to get around it?

Thanks

[Susan]

mike said HIDE the first three columns after you get them
concatenated.
:)
susan


On Jul 22, 8:16*am, Megglesface
wrote:
Ok that great, thanks, I have merged the three columns into one, but the
original three columns are still showing.
When i delete them this obviously deletes the new merged column too.

do you know how to fix this?

Thanks



"Mike H" wrote:
Hi,

Concatenate them into a third column and Hide the original 3

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

Mike

"Megglesface" wrote:

I have three colums in excel, column A has a number in it, column B a name
and column C an address.
i want to merge them so that the number, name and address of each person is
in one cell.
when I select the three cells and click merge it brings up an error message
saying that the values in the cells are different and merging will keep only
the info from column A.
anyone know why this is happening or how to get around it?

Thanks- Hide quoted text -

- Show quoted text -

[Megglesface]

oops, sorry. thats what I get for reading in a rush! thanks to you both

"Susan" wrote:

mike said HIDE the first three columns after you get them
concatenated.
:)
susan


On Jul 22, 8:16 am, Megglesface
wrote:
Ok that great, thanks, I have merged the three columns into one, but the
original three columns are still showing.
When i delete them this obviously deletes the new merged column too.

do you know how to fix this?

Thanks



"Mike H" wrote:
Hi,

Concatenate them into a third column and Hide the original 3

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

Mike

"Megglesface" wrote:

I have three colums in excel, column A has a number in it, column B a name
and column C an address.
i want to merge them so that the number, name and address of each person is
in one cell.
when I select the three cells and click merge it brings up an error message
saying that the values in the cells are different and merging will keep only
the info from column A.
anyone know why this is happening or how to get around it?

Thanks- Hide quoted text -

- Show quoted text -

[Gord Dibben]

Copy the new column and EditPaste SpecialValuesOKEsc

Delete the originals.


Gord Dibben MS Excel MVP

On Tue, 22 Jul 2008 05:16:00 -0700, Megglesface
wrote:

Ok that great, thanks, I have merged the three columns into one, but the
original three columns are still showing.
When i delete them this obviously deletes the new merged column too.

do you know how to fix this?

Thanks


"Mike H" wrote:

Hi,

Concatenate them into a third column and Hide the original 3

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

Mike

"Megglesface" wrote:

I have three colums in excel, column A has a number in it, column B a name
and column C an address.
i want to merge them so that the number, name and address of each person is
in one cell.
when I select the three cells and click merge it brings up an error message
saying that the values in the cells are different and merging will keep only
the info from column A.
anyone know why this is happening or how to get around it?

Thanks