| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| putting 2 long columns into multiple columns in excel page and sor | Excel Discussion (Misc queries) | |||
| Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
| Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
| "Text to Columns" for many columns in Excel 2003 | Excel Discussion (Misc queries) | |||
| unable to insert columns in excel, insert- columns (disabled) | Excel Discussion (Misc queries) | |||
Hybrid Mode
