How to Insert Double or Single Quotes
To Create New Quoted Values from Unquoted Values
- Column A contains the names.
- Put the following formula into Column B
= """" & A1 & """"
- Copy Column B and Paste Special -> Values
Using a Custom Function
Public Function Enquote(cell As Range, Optional quoteCharacter As String = """") As Variant Enquote = quoteCharacter & cell.value & quoteCharacterEnd Function
To get permanent quoted strings, you will have to copy formula values and paste-special-values.