CONCATENATE CRAZY!

  • Thread starter Thread starter lalab8
  • Start date Start date
L

lalab8

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.
 
Try this:

D2 = Pittsburgh
E2 = PA
F2 = 15222

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

Returns:

Pittsburgh PA 15222

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

Returns:

Pittsburgh, PA, 15222
 
Back
Top