CONCATENATE CRAZY!
 

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

CONCATENATE CRAZY!
 

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

CONCATENATE CRAZY!
 

Thanks a lot. That worked and was very easy.
--
lala


"T. Valko" wrote:

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

CONCATENATE CRAZY!
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"lalab8" wrote in message
...
Thanks a lot. That worked and was very easy.
--
lala


"T. Valko" wrote:

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