-2

I have a 502 entry column and I want to enclose each entry with quotes around each entry.

Example:

www.google.com -> "www.google.com"
www.twitch.tv -> "www.twitch.tv"
www.bbc.com -> "www.bbc.com"
marikamitsos
  • 7,740
  • 14
  • 25
Svendy1126
  • 39
  • 1
  • 6
  • How does that answer my question? – Svendy1126 Oct 14 '20 at 17:45
  • 1
    As much as I appreciate your help. If I knew the details on how to solve the said problem, the problem wouldn't be a "problem". That's exactly why I came here - looking for answers and solutions. I am pretty clear with what I asked for. I want my entries enclosed in quotes. Your solution solves my problem, so if you want to add it as a post I'll accept it as an answer. Thanks. – Svendy1126 Oct 14 '20 at 17:58

1 Answers1

0

Please use the following

=REGEXREPLACE(P2,"(.*)","""$1")

enter image description here

Or for the whole range

=ArrayFormula(IF(P2:P="",,REGEXREPLACE(P2:P,"(.*)","""$1")))

Functions used:

marikamitsos
  • 7,740
  • 14
  • 25