Outputting strings with quotation marks

  • Thread starter Thread starter Alan
  • Start date Start date
A

Alan

I need to take text strings in a column and output them in a text
file with double quotation marks (") around them (for processing by
another, existing program). I cannot figure out how to do this by
saving an excel file as a text file.
Thanks, Alan
 
With data in Column A,
Enter this in B1:

=""""&A1&""""

And copy down as needed.

Now, to remove the formulas, and leave the data behind,
While the column is *still* selected from the formula "Copy",
Right click in the selection and choose "Copy",
Right click again and choose "Paste Special",
Click on "Values", then <OK>, then <Esc>.

You should now have your column of data enclosed in quotes.
 
Thank you. This was just the trick.
With data in Column A,
Enter this in B1:

=""""&A1&""""

And copy down as needed.

Now, to remove the formulas, and leave the data behind,
While the column is *still* selected from the formula "Copy",
Right click in the selection and choose "Copy",
Right click again and choose "Paste Special",
Click on "Values", then <OK>, then <Esc>.

You should now have your column of data enclosed in quotes.
Click to expand...
 
Back
Top