HOW TO COMBINE DATA FROM 2 COLUMNS

Hello,

I want to combine the data from 2 columns and move it all to the first 
column.  A simple task I thought, but I can't find how to do it.   I had a 
text file with addresses in it and it formatted with the street name and the 
descriptor such as Way, Drive, etc in a separate column..  I want to take

First              Street       (2 columns)  and make it
First Street    (1 column)

Thanks,
Evelyn Fassett
 

Evelyn:
> I want to take
> 
> First              Street       (2 columns)  and make it
> First Street    (1 column)

One way: if First is in A2 and Street is in B2:
then in any other Cell (perhaps D2): +A2&" "&B2
You can Copy the formula down the Rows.

You can Select the output Cells and choose
Edit|Convert to Values|[OK]

You can move or delete the original Cells.
-- 
Good wishes!
Roy Lewis
C_Tech volunteer
(UK)