Excel, how can cells be combined?

[ehlmason]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Power PC

In an address book that has been exported to Excel, City, State and Zip are in separate, adjacent cells. On another sheet, pulling that data, I would like to combine the three cels into a single cell with spacing that automatically adjusts, i.e., if the city is a long name, it zip follow with small spaces in between. Using the merge cells feature does not accomplish this.

Is there an easy way to do this, other than retyping all of the fields?

 

[JE McGimpsey]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Power PC

In an address book that has been exported to Excel, City, State and Zip are
in separate, adjacent cells. On another sheet, pulling that data, I would
like to combine the three cels into a single cell with spacing that
automatically adjusts, i.e., if the city is a long name, it zip follow with
small spaces in between. Using the merge cells feature does not accomplish
this.

Is there an easy way to do this, other than retyping all of the fields?

One way:

Assume

C D E
<city> <state> <5 digit zip>

and that you want the total length of the cell to be, say, 40 characters:


=LEFT(C2 & ", " & D2 & REPT(" ", 33), 35) & E2