how to use ' symbol as text?

[evgeniystuchalk]

Hello! I need generate string like onClick="window.open('LINK'), where LINK is gegenrated link from formula, onClick="window.open(' and ') is fixed text parts. Touble with ' symblos around LINK.

When i'm tryen something like 'onClick="window.open(''&LINK&'')', formula does not work. How i can bypass it?

[Jason_Michaelides · Accepted solution]

Use Chr(39) instead. For example, to get:

Hello my name is 'Jason'

use

='Hello my name is ' & Chr(39) & 'Jason' & Chr(39)

Hope this helps,

Jason

[evgeniystuchalk]

Yes, it works, thanks)

[swuehl]

Alternatively, you can also use escape sequences:

Escape sequences

='Hello my name is ''Jason'''