Hi Kevin/Madhu

Thanks for your inputs.
However i was trying the same thing it did not work in Ms 2007.

Tried with below formula:

=CHAR(34)&A2&CHAR(34)

I am not sure whether MS 2007 supports only this formula.

Regards,
Uma

"Kevin B" wrote:

Save your original file under a new name before proceeding.

If necessary insert a blank column to the right of your data, and enter the
following formula changing the A1 cell address to the first cell of the data
column you need modified:

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

That is 4 double quotes after the equal sign on the left and 4 double quotes
following the ampersand on the right.

Copy the formula down to the last row of data.

Now, all the data in your formula column and press <Ctrl + C to copy it to
the clipboard. Click the first cell of your original data column and click
EDIT in the menu and select PASTE SPECIAL. In the PASTE SPECIAL dialog box
click the VALUES option button and click OK to complete the paste. You can
now delete the helper column
--
Kevin Backmann


"Uma Nandan" wrote:

Hi,

Please find below my data:
I have some data as mentined in current data

I would require the out put as mentioned in Required output column.
can some one help me with this?

I have 10k Data where in i need to use this double quotes.


Current Data Required Output
VP, Engineering Governance " VP, Engineering Governance "
CEO, Global Investment Banking "CEO, Global Investment Banking"

Thanks in advance.

Regards,
Uma