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


THANKS!
This works perfect! Exactly as I want it to work - you have saved many hours for me :-)

Kind regards,
Marino

-----Ursprungligt meddelande----- From: Errol Goetsch
Sent: Monday, July 8, 2013 11:27 PM
To: users@global.libreoffice.org
Subject: Re: [libreoffice-users] Info from 3 cells merged into 1

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


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
Errol

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

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

Best regards,
Marino

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

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

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: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Context


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.