Hi Nils,
Nils Lundvang schrieb:
I have a column with different texts (handles of products)…I would like
to insert the following in front of the existing text of all the
cells..all the way down. How is this done?
the following text is what is to be inserted. See the attached file for
the column with the cells that need the text in front of it.
http://bandofjules.com/products/
<http://bandofjules.com/products/willow-gold> should be in front of
all these:
and here a solution with regular expression:
Mark all those cells
Open Find&Replace dialog
click on More options
mark "Regular expressions" and "Current selection only"
In Find field write
(.+)
in Replace field write
<http://bandofjules.com/products/willow-gold>$1
Replace All
Explanation:
.+ means at least one character, character is arbitrary
the brackets establish a reference
$1 uses this reference to keep the old content
As always with Find&replace, make a backup or at least save before using
"Replace All".
Kind regards
Regina
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
