<div>
You can apply this formula...<br />
<br />

<pre><code id="code-20-40908285-1">=&quot;(&quot;&amp;A1&amp;&quot;'),&quot;</code></pre>
<br />
In b1 and drag this this will do what you are looking for..You don't need VBA Code for it...<br />
<br />
Saurabh...
</div>


You can apply this formula...



="("&A1&"'),"


In b1 and drag this this will do what you are looking for..You don't need VBA Code for it...

Saurabh...

<div>
<div class="content wysiwyg-content">
I have data in a sheet in column A that looks like below. &nbsp;<br />
<br />
07117547_F<br />
07031696_G<br />
<br />
I need help with a macro to make the data look like this in column B below: (includes parentheses, apostrophes, and a comma)<br />
<br />
('07117547_F'),<br />
('07031696_G'),<br />
<br />
Thanks.
</div>
</div>


I have data in a sheet in column A that looks like below.  

07117547_F
07031696_G

I need help with a macro to make the data look like this in column B below: (includes parentheses, apostrophes, and a comma)

('07117547_F'),
('07031696_G'),

Thanks.

ms excel vba code to add characters from one column to second column

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