How to get double quotes to show up after pasting?

I need to copy text surrounded by double quotes (for example "example") from
another application and paste it in Excel. After pasting, the double quotes
disappear in Excel, while I don't want that. (pasting "example" results in a
cell showing the word example, while it should be "example").
Does anyone know how I can set up Excel so that it doesn't manipulate the
text string and just pasts it exactly as it is copied to the clipboard?
Appreciate your help.

Did you try formatting the cells as 'text' before copying the data into excel?

"SusanG" wrote:

> I need to copy text surrounded by double quotes (for example "example") from
> another application and paste it in Excel. After pasting, the double quotes
> disappear in Excel, while I don't want that. (pasting "example" results in a
> cell showing the word example, while it should be "example").
> Does anyone know how I can set up Excel so that it doesn't manipulate the
> text string and just pasts it exactly as it is copied to the clipboard?
> Appreciate your help.

Yes - it doesn't help.
The strange thing is copying "example" from a cell in Excel and pasting in
another cell goes correctly, but pasting from another application Excel
removes the double quotes. I'm pretty sure Excel does this because pasting in
another text editor keeps the double quotes which would indicate the quotes
being there in on the clipboard.
Thanks for your input.

"tim m" wrote:

> Did you try formatting the cells as 'text' before copying the data into excel?
>
> "SusanG" wrote:
>
> > I need to copy text surrounded by double quotes (for example "example") from
> > another application and paste it in Excel. After pasting, the double quotes
> > disappear in Excel, while I don't want that. (pasting "example" results in a
> > cell showing the word example, while it should be "example").
> > Does anyone know how I can set up Excel so that it doesn't manipulate the
> > text string and just pasts it exactly as it is copied to the clipboard?
> > Appreciate your help.

Hi,

This occurs due to Text To Columns -settings.
Change TextQualifier to be xlNone and problem is solved.. Unfortunately, his has to be done every time when you open the Excel.

Selection.TextToColumns Destination:=Range("E4"), DataType:=xlDelimited, _
TextQualifier:=xlNone, ConsecutiveDelimiter:=False, Tab:=False, _
Semicolon:=False, Comma:=False, Space:=False, Other:=False, FieldInfo _
:=Array(1, 1), TrailingMinusNumbers:=True

Do it like this and Excel changes the settings every time you open the Excel:

Private Sub Workbook_Open()
Dim ggg As Range

Set ggg = Cells.Find(What:="*", After:=Range("a1"), LookIn:=xlFormulas, LookAt:= _
xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _
, SearchFormat:=False)
If ggg Is Nothing Then
Set ggg = Range("a1")
ggg.Value = "x"
ggg.TextToColumns Destination:=ggg, DataType:=xlDelimited, _
TextQualifier:=xlNone, ConsecutiveDelimiter:=False, Tab:=False, _
Semicolon:=False, Comma:=False, Space:=False, Other:=False, FieldInfo _
:=Array(1, 1), TrailingMinusNumbers:=True
ggg.Value = ""

Else
ggg.TextToColumns Destination:=ggg, DataType:=xlDelimited, _
TextQualifier:=xlNone, ConsecutiveDelimiter:=False, Tab:=False, _
Semicolon:=False, Comma:=False, Space:=False, Other:=False, FieldInfo _
:=Array(1, 1), TrailingMinusNumbers:=True
End If

End Sub