Hi Brian,
a literal is a text. If you want to replace a number which is formatted
as text by having a single quote as the first character then you can
start the replace string with a single qoute ' to leave it as a literal.
Alternatively you can format this number string as text (menu item
format cell)
In both cases search&replace replaces the string accordingly
Kind regardsm Joost
Am 03.05.2021 um 14:09 schrieb Brian Barnard:
In your spreadsheet handler I recently tried to edit a column of literals
(all numeric) but your find and replace would not replace the
characters that I entered with the new ones. In the same column were
alphabetic literals and I could replace these with no problem. As a result
of this I have had to buy Office 2019 and uninstall Open Office
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
