Merging or Combining 2 columns of data into 1 column

[Josh]

I am trying to merge 2 columns of data together into 1
column. Maintaining both sets of data in a single column
seperated with only a space between the two.

For example:
Column A has 100 rows of information.
Column B has 100 rows of information.

I want to combine both columns so that each of Column A
information and each of Column B information reside in
Column A. With with just a space seperating the two data
sets.

Is this possible....? If so, HOW.....?

Thank You,

Josh

 

[J.E. McGimpsey]

One way:

C1: =A1 & " " & B1

Copy to C100

Copy Column C

Select Column A

Edit Paste Special, selecting the Values radio button.

Delete columns B & C.