At 16:23 12/09/2014 +0200, Nils Lundvang wrote:
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/ should be in front of all these:
Are we talking about a spreadsheet column or
perhaps a column of a table in a text document?
Suppose your existing text is in column A of a
spreadsheet, starting in cell A1.
o In row 1 of a suitable spare column, enter
="http://bandofjules.com/products/"&A1 ("&" is the concatenation operator).
o Fill this formula down its column as necessary.
o Select all the resulting values.
o Copy.
o Paste the results back over the original
column, but using Edit | Paste Special (or
right-click | Paste Special... or Ctrl+Shift+V)
instead of ordinary Paste. In the Paste Special
dialogue, remove the tick from "Paste all" if
necessary and ensure that Formulae is *not* ticked.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
