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

colingsmith
23 ●1 ●1 ●4

manj_k
10965 ●15 ●68 ●100

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 +0100 )edit

Sort by » oldest newest most voted

7787 ●10 ●43 ●84

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 +0100

Seen: 12,155 times

Last updated: Feb 19 '13