View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Excel Spreadsheet combining data from 3 columns to 1 column

See

http://www.mcgimpsey.com/excel/subs/mergedata.html

In article ,
Lotto Man <Lotto wrote:

I have 3 columns in Excel City, State, and Zip Code. I want to combine
them into 1 column. Each column has about 1000 entries. Copy and paste
don't work How do I accomplish this?