How do I put "quote marks" around a column of text? [closed]

colingsmith
23 ●1 ●1 ●4

manj_k
10975 ●15 ●68 ●101

Hi,

I am trying to figure out how to put quotation marks, " ", around a column of text in Libre Calc.

Does anyone know how to do this easily?

Thanks, Colin

Comments

Thank you JohnSUN, excellent answer that works!

colingsmith ( 2013-02-19 14:19:27 +0200 )edit

Sort by » oldest newest most voted

7842 ●10 ●43 ●85

Press Ctrl+H or choose Edit - Find & Replace

Search: .+ (dot and plus)

Replace with: "&" (quote - ampersand - quote)

More options - Regular expressions - On

Quotes

Asked: 2013-02-19 11:59:25 +0200

Seen: 14,218 times

Last updated: Feb 19 '13