Excel 97 Two columns to .csv fFormat
 

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

Thanks

Charlie

Excel 97 Two columns to .csv fFormat
 

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 editpaste special(in place)valuesokesc

Delete columns A and B

Then Filesave asfile type*.csv


Gord Dibben MS Excel MVP

On Sat, 4 Apr 2009 18:23:01 -0700, sswcharlie
wrote:

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

Thanks

Charlie