merge cells?

[alanb]

Hi - I have a simple workbook that has city, state and zip code in 3 cells
[say a1, b1 and c1]. I need to merge these into one cell, but upon doing
this in the formatting menu, it only leaves the text from A1. I have tried
formatting all text to 'general', 'text', etc., all with the same
[incorrect] result.
your help is appreciated!
Alan

 

[Norman Harker]

Hi Alan!

Have you tried:

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

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Norman Harker]

Hi Alan!

I sent before explanation and additions.

Merging cells will always take the leftmost of three occupied cells.

Better to concatenate and then you can select the concatenated cells
and use:

Copy
Edit > Paste Special > Values

The existing three columns can then be deleted.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

Hi Alan!

Have you tried:

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

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

Hi - I have a simple workbook that has city, state and zip code in

3

cells
[say a1, b1 and c1]. I need to merge these into one cell, but

upon

doing
this in the formatting menu, it only leaves the text from A1. I have tried
formatting all text to 'general', 'text', etc., all with the same
[incorrect] result.
your help is appreciated!
Alan

 

[alanb]

Hi Norman -
It works beautifully and I appreciate your help! best of the New Year to
you!
Alan

Hi Alan!

I sent before explanation and additions.

Merging cells will always take the leftmost of three occupied cells.

Better to concatenate and then you can select the concatenated cells
and use:

Copy
Edit > Paste Special > Values

The existing three columns can then be deleted.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

Hi Alan!

Have you tried:

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

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

Hi - I have a simple workbook that has city, state and zip code in

3

cells
[say a1, b1 and c1]. I need to merge these into one cell, but

upon

doing
this in the formatting menu, it only leaves the text from A1. I have tried
formatting all text to 'general', 'text', etc., all with the same
[incorrect] result.
your help is appreciated!
Alan