Fastest way to write an excel formula into an entire column

To put “” within a string, there are multiple options I read about on this forum.
For me not all of them worked, so maybe try different ones.
Say, you want to print the following text in a message box: welcome"guest"
Options to put in your string:

  1. “Welcome”+”“”“+“Guest”+”“”"
  2. “Welcome”+”“”+“Guest”+“”"
  3. “Welcome”+ Chr$(34) +“Guest”+Chr$(34)

Those are the options I found, for me only option 1 works

1 Like