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+unsubscr...@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
