Try this:

D2 = Pittsburgh
E2 = PA
F2 = 15222

=D2&" "&E2&" "&F2

Returns:

Pittsburgh PA 15222

=D2&", "&E2&", "&F2

Returns:

Pittsburgh, PA, 15222

--
Biff
Microsoft Excel MVP


"lalab8" wrote in message
...
HELP!! Okay, so I'm not an expert in Excel, please bear with me... I have
a
very simple worksheet where column D1 is labeled Town, column E1 is
labeled
ST and column F is labeled, you guessed it, ZIP. All I want to do is
combine
the data in those cells and subsequent data in rows 2 - 671 into one
column.
Does anyone know of an easy way to accomplish this? Thanks in advance for
any help you can provide.
--
lala