0

I have a long row of SYMBOLS. Example: AAA BBB CCC .. .. Etc.

I need to add " " around the symbols and I need to ad a comma at the end of the symbol. My row should look like this: "AAA", "BBB", "CCC", ... "ZZZ",

Improve this question
3
  • Why do you need it in this particular format? CSV files wouldn't need the quotes around each string.
    – Ron Rosenfeld
    Apr 22, 2021 at 11:34
  • Is it a single cell with a long string of text, or something else?
    – Christofer Weber
    Apr 22, 2021 at 11:51
  • the formula =Substitute() might work
    – gns100
    Apr 22, 2021 at 20:59

1 Answer 1

Reset to default
0
  1. Use Replace function.

enter image description here

Result: enter image description here

  1. Use formula =CHAR(34)&A1&CHAR(34) in an empty cell. enter image description here
Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .