Page 1 of 1

[Solved] Convert number to text string

Posted: Tue Sep 03, 2013 1:18 pm
by Nikos
Hello community,

in libreoffice calc I would like to convert (preferably via search and replace) all numbers to text strings (e.g. number 15 to text string '15).

Any suggestions?

Kind regards

Nikos

Re: Convert number to text string

Posted: Tue Sep 03, 2013 1:35 pm
by ken johnson
Select those cells then change format to Text (@) then use these settings in the Find & Replace dialogue...
Search for...
.+
Replace with...
&
Current selection only
Regular expressions
Search in...
Values

Ken Johnson

Re: Convert number to text string

Posted: Tue Sep 03, 2013 1:40 pm
by Nikos
Thank you!

Re: [Solved] Convert number to text string

Posted: Mon Oct 19, 2015 7:25 pm
by GuccizBud_Temp
Select those cells then change format to Text (@) then use these settings in the Find & Replace dialogue...
Search for...
.+
Replace with...
&
Current selection only
Regular expressions
Search in...
Values

Ken Johnson
VERY smart :bravo: and allowed me to discover that "Search in... <anything other than formulas>" setting, which can be very useful... bravo. :super: