Quote Originally Posted by Paul_Hossler View Post
Try

Dim prefix As String


prefix = "'" & Right(x, Len(x) - 20)   '    DoubleQuote SingleQuote DoubleQuote 


thank you - that worked