Excel 97 Two columns to .csv fFormat

S

sswcharlie

I have column A and b and want to combine and save as a csv file fo export.
What is the procedute

Thanks

Charlie
 
G

Gord Dibben

In C1 enter =A1&B1 and double-click on the fill handle of C1

Or =A1&" "&B1 if you want a space.

Copy column C and edit>paste special(in place)>values>ok>esc

Delete columns A and B

Then File>save as>file type>*.csv


Gord Dibben MS Excel MVP
 
Top