Excel 97 Two columns to .csv fFormat

  • Thread starter Thread starter sswcharlie
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel CSV Files; Creating Of 3
.csv Commas ? 2
.csv Format, Hidden Columns, 2007 2
Excel And Notepad 3
2007 Worksheet, Hidden Columns, .CSV Format Saves Hidden Column Da 3
*.csv format change if .xlt save as .csv in Excel 2007 1
CSV to Excel 3
["\r\n" new line command in CSV file] 1

Back
Top