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

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