<div>
Can you upload sample? Both files: excel source and text file with result.
</div>


Can you upload sample? Both files: excel source and text file with result.

EE-Q28510838.xlsx

<div>
PS &nbsp;If you need the values bound by apostrophes:<br />
<br />
B1: &nbsp;<b>=&quot;'&quot;&amp;A1&amp;&quot;'&quot;</b><br />
B2: <b>=B1&amp;&quot;,&quot;&amp;&quot;'&quot;&amp;A2&amp;&quot;'&quot;</b> (copied down)<br />
<br />
-Glenn
</div>


PS  If you need the values bound by apostrophes:

B1:  ="'"&A1&"'"
B2: =B1&","&"'"&A2&"'" (copied down)

-Glenn

<div>
If I understand the question, Glen Ray has it the &quot;nail on the head&quot;. &nbsp;I have used that formula many times.
</div>


If I understand the question, Glen Ray has it the "nail on the head".  I have used that formula many times.

<div>
<div class="content wysiwyg-content">
Is there any possible to way to achieve the following.<br />
<br />
I have an excel spreadsheet with a single column of data (in column A), the values are text/numerical, e.g. E45678, F45679. I need a way to export all the values to a text file into the following format:<br />
<br />
('first cell of data', 'second cell of data', third cell of data')<br />
<br />
ready for importing into a where clause on an external RDBMS. Is this possible? I know there is concatenate but with upwards of several hundred entries it would take an age to write such a formula, I need something more automated.
</div>
</div>


Is there any possible to way to achieve the following.

I have an excel spreadsheet with a single column of data (in column A), the values are text/numerical, e.g. E45678, F45679. I need a way to export all the values to a text file into the following format:

('first cell of data', 'second cell of data', third cell of data')

ready for importing into a where clause on an external RDBMS. Is this possible? I know there is concatenate but with upwards of several hundred entries it would take an age to write such a formula, I need something more automated.

excel column of data export format

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.