- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
I store my Bookmarks in this format . . .
If I have the word "Description" in one cell, and a URL in the other, and then CONCATENATE them . . . =CONCATENATE(R2 &" . . . "& S2)
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
1.) The word, and no second line within the word cell, quotes or no quotes around the words, concatenates fine:
"Description" . . . https://www.google.com/
Description . . . https://www.google.com/
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
2.) If there is a hard return (Alt+Enter) within the word cell, and something else on the next line(s):
a.) It puts another pair of quotes, around the quotes
b.) It puts the whole thing in quotes
Is there a way to keep it from doing this?
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
=CONCATENATE(R4 &" . . . "& S4)
"""Description""
Description . . . https://www.google.com/"
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
"Description
Description . . . https://www.google.com/"
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Bookmarks