Re: [libreoffice-users] Info from 3 cells merged into 1

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