Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
Yes, it works, thanks)