How to enclose all cells with quotation marks?

Question

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"

You haven't given much in the way of details of how you want to solve the problem (formula, script, find-replace), so that's why I commented instead of answering. Have you tried to use find+replace to do it? Find `(^.*$)`, Replace with `"$1"` within your column, turn on regular expressions. — Calculuswhiz, Oct 14 '20 at 17:50
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
Sorry. Didn't mean to be so terse. Just wanted to know what you tried. — Calculuswhiz, Oct 14 '20 at 18:23

score 0 · Accepted Answer · answered Oct 14 '20 at 17:57

0

Please use the following

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

Or for the whole range

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

Functions used:

answered Oct 14 '20 at 17:57

marikamitsos

1 Answers1