content/documentation/faqs/spreadsheet/037.html

<meta http-equiv="REFRESH" content="10;url=http://wiki.services.openoffice.org/wiki/Documentation/FAQ">
<h3>This page is outdated. You will be redirected to <a href="http://wiki.services.openoffice.org/wiki/Documentation/FAQ">http://wiki.services.openoffice.org
/wiki/Documentation/FAQ</a> shortly.</h3>
<div style="margin-bottom: 10em;"></div>
<p><a href="../../index.html">Documentation</a> / <a
 href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
 href="036.html" accesskey="p">Previous</a>-<a href="038.html"
 accesskey="n">Next</a></p>
<h3>How do I add trailing characters to a cell?</h3>
<p>If what you have are index numbers like "DCP_5509" in column B and
you want to add a common suffix like "myparty.jpg" to the end of this
existing data, then enter the function <b>=CONCATENATE(B1;"myparty.jpg")</b>
into a new cell that will show the index number from cell B1 with the
new suffix attached. Next, apply this function to the rest of the cells
in the new column. Copy the first cell in the new column, then paste it
to the remaining cells in that column. Now the new column displays
"DCP_5509myparty.jpg" and the like.</p>
<p><b>Note: </b>Alter the function to <b>=CONCATENATE("myparty.jpg";B1)</b>
to add the additional characters as a prefix to the existing data from
cell B1.</p>
<p><a href="../../index.html">Documentation</a> / <a
 href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
 href="036.html" accesskey="p">Previous</a>-<a href="038.html"
 accesskey="n">Next</a></p>