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: [email protected]
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: [email protected]
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: [email protected]
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: [email protected]
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
