Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index

oops, perhaps attachments get stripped out on this list. I've now sent the example direct to Marino.

On 2013/07/08 10:10 PM, Errol Goetsch wrote:
err501 means the formula was written incorrectly.
here is a working example of what Steve and Carl said

On 2013/07/08 09:57 PM, Marino / wrote:
Thanks Steve!

Ive tried this now, but I got Err:501 for this. Any idea why?

Best regards,

-----Ursprungligt meddelande----- From: Steve Edmonds
Sent: Monday, July 8, 2013 7:46 PM
To: Marino /
Subject: Re: [libreoffice-users] Info from 3 cells merged into 1

In the cell D1 where you want the result, you use =CONCATENATE(A1,B1,C1).
On 2013-07-09 05:31, Marino / wrote:

I woud like to know if following is possible:
I am about to create an importfile for my products in a webshop. Here I must have the name of all images and its path and file extansion. The path is always the same, but the name of the image is individual for each product. My idea is to have one column with name of the path, lets say column "A" includes the name of the path "data/" and column "B" has the name of the image "12345" and column "C" has the name for the file extansion ".jpg" or ".png".

So far all is ok. But now I would like to have these 3 facts together, so column "D" would include facts from column "A"+"B"+"C", so in column "D" I can see "data/12345.jpg".

Is there a way to make this happen?

- Thanks in advance!

Best regards,
Marino Assarsson


To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.