-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
  • 10,264
  • 20
  • 26
Svendy1126
  • 77
  • 1
  • 8
  • 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
  • 10,264
  • 20
  • 26