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
[Solved] Convert number to text string
[Solved] Convert number to text string
Last edited by Nikos on Tue Sep 03, 2013 1:40 pm, edited 1 time in total.
LibreOffice 25.2 on Kubuntu 25.4 (flatpak) + LibreOffice 25.2 on Ubuntu 25.4 (flatpak)
-
ken johnson
- Volunteer
- Posts: 918
- Joined: Sun May 31, 2009 1:35 am
- Location: Sydney, Australia
Re: Convert number to text string
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
Search for...
.+
Replace with...
&
Current selection only
Regular expressions
Search in...
Values
Ken Johnson
AOO 4.1.3 on Ms Windows 10
Help improve this forum by clicking the EDIT button on your first post then adding "[Solved]" to its heading once a solution to your problem has been provided.
Help improve this forum by clicking the EDIT button on your first post then adding "[Solved]" to its heading once a solution to your problem has been provided.
Re: Convert number to text string
Thank you!
LibreOffice 25.2 on Kubuntu 25.4 (flatpak) + LibreOffice 25.2 on Ubuntu 25.4 (flatpak)
-
GuccizBud_Temp
- Posts: 3
- Joined: Fri Jan 23, 2015 12:13 am
Re: [Solved] Convert number to text string
VERY smartSelect 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
and allowed me to discover that "Search in... <anything other than formulas>" setting, which can be very useful... bravo. 
OOo 4.1.1 on Win 7 Pro x64