=CONCATENATE("www.mysite.co/images/", A1,".jpg")
A1 is of course R1C1
Melanie Phair wrote:
> Hi Scott,
>
> On Fri, 8 Nov 2002 09:13:38 -0800, you wrote:
> >Probably the easiest way to do it is to create an comma delimited
> ASCII
> >file with an extension of '.CSV'. This is a recognized excel
> extension
> >and just double clicking the created file will open it in excel. You
> can
> >use straight SQL to create the comma delimited file, so you can stop
> >quelling over the all the excel modules that you think you might
> need.
> >Try something like this:
> >
> >SELECT your_fields_here INTO OUTFILE 'your_filename.csv' FIELDS
> >TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY
> "\n"
> >FROM your_tables_here WHERE your_where_statements_here
> >
> Great. I was almost there but that got me safely to the destination.
> Thanx
>
> I have another excel question which I will ask here just in case we
> have any excel gurus lurking in the shadows.
>
> Column a contains numeric data, say 100,101,102.....etc
>
> In another column I want to put a web link in the form of
>
> www.mysite.co/images/xxx.jpg
>
> where xxx is the value in column a of the respective row.
>
> I guess I need some form of concatenation but I can't figure the
> syntax.
>
> Anyone any ideas ?
>
> regards
>
> melanie
>
> ____ � The WDVL Discussion List from WDVL.COM � ____
> To Join wdvltalk, Send An Email To: mailto:wdvltalk-join@;lists.wdvl.com
> Send Your Posts To: [EMAIL PROTECTED]
> To change subscription settings to the wdvltalk digest version:
> http://wdvl.internet.com/WDVL/Forum/#sub
>
> ________________ http://www.wdvl.com _______________________
>
> You are currently subscribed to wdvltalk as: [EMAIL PROTECTED]
> To unsubscribe send a blank email to %%email.unsub%%
____ � The WDVL Discussion List from WDVL.COM � ____
To Join wdvltalk, Send An Email To: mailto:wdvltalk-join@;lists.wdvl.com
Send Your Posts To: [EMAIL PROTECTED]
To change subscription settings to the wdvltalk digest version:
http://wdvl.internet.com/WDVL/Forum/#sub
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
