Excel Spreadsheet combining data from 3 columns to 1 column
If in columns A, B and C
in column D
in D1: =A1&B1 & C1
or =A1 & " " & " " & B1 & " " & C1
to give a space between each field
Copy down and then copy/paste special-values
Or look at CONCATENATE function
"Lotto Man" 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?
|