Originally Posted by Paul_Hossler Try Dim prefix As String prefix = "'" & Right(x, Len(x) - 20) ' DoubleQuote SingleQuote DoubleQuote thank you - that worked
Dim prefix As String prefix = "'" & Right(x, Len(x) - 20) ' DoubleQuote SingleQuote DoubleQuote
View Tag Cloud
Forum Rules