merge cells?

  • Thread starter Thread starter alanb
  • Start date Start date
A

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
 
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 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.
Norman Harker said:
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.
alanb said:
Hi - I have a simple workbook that has city, state and zip code in
Click to expand...
3
cells
[say a1, b1 and c1]. I need to merge these into one cell, but
Click to expand...
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
Click to expand...
Click to expand...
 
Hi Norman -
It works beautifully and I appreciate your help! best of the New Year to
you!
Alan

Norman Harker said:
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.
Norman Harker said:
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.
alanb said:
Hi - I have a simple workbook that has city, state and zip code in
Click to expand...
3
cells
[say a1, b1 and c1]. I need to merge these into one cell, but
Click to expand...
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top