View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
muddan madhu muddan madhu is offline
external usenet poster
 
Posts: 747
Default How to insert special characters in a cell

suppose u have data in A1 put this formula in B1 ="''"&A1&"''"



On Sep 26, 8:30*am, 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