How to put quotes in bulk in Excel or txt strings?

Question

Search Engine Optimization

Given 3000 different words (or phrases), each of which is written on a separate line. Each phrase must be wrapped in quotation marks "".
How to do it automatically and in bulk?
I also have a Notepad++ editor, maybe it is possible to do this in bulk with regular expressions?

Answer 1

It can be even easier. Copy everything to the first column, line by line
In the second, write
And drag this entry to the last.

Answer 2

Good afternoon!
Solution using Excel:
1. Column A - all your strings
2. Column B - quotes
3. Column C - =CONCATENATE(B1;A1;B1)

Answer 3

Notepad++ regex
Find: (^.+$)
Replace:"(\1)"

Answer 4

If it's quick and easy, then:
1. open the list in notepad++
2. search (ctrl + F), "Replace" tab
3. In the field find: \r\n, in the field replace with: "\r\n"
4. Search Mode - Advanced
Click "Replace All", then put one quote at the very beginning of the list, and remove it at the very end. Ready

Answer 5

Notepad++ press alt+c

Answer 6

Copy all lines in 1 column in Excel
Create a macro.
Write in a macro

For i = 1 To сюда ваша последняя цифра в столбике прим 3000
Cells(i, 1) = Chr(34) & Cells(i, 1) & Chr(34)
Next i

And run

Answer 7

I would convert to CSV and do it via sed in the console. But, IMHO, there are more appropriate ways inside Excel, macros, etc.