This works for me:
=CONCATENATE("""",A1,"""")
Repeating the quotes escapes them (as it does in Visual Basic, I believe), so """" reads as: ‘one quote to start a string, one escaped quote (“”), then one quote to finish the string’.
This works for me:
=CONCATENATE("""",A1,"""")
Repeating the quotes escapes them (as it does in Visual Basic, I believe), so """" reads as: ‘one quote to start a string, one escaped quote (“”), then one quote to finish the string’.