<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1479" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=277102200-31052005><FONT face=Arial color=#0000ff size=2>You
need to concatenate your student's name with the text you wish to add -
eg</FONT></SPAN></DIV>
<DIV><SPAN class=277102200-31052005><FONT face=Arial color=#0000ff size=2>=A3
& " Has worked well"</FONT></SPAN></DIV>
<DIV><SPAN class=277102200-31052005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=277102200-31052005><FONT face=Arial color=#0000ff size=2>The
ampersand is the concatenation operator; the text you wish to add has to be in
inverted commas.</FONT></SPAN></DIV>
<DIV><SPAN class=277102200-31052005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=277102200-31052005><FONT face=Arial color=#0000ff
size=2>Cheers</FONT></SPAN></DIV>
<DIV><SPAN class=277102200-31052005><FONT face=Arial color=#0000ff size=2>Ron
Lel</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
ipm-bounces@edulists.com.au [mailto:ipm-bounces@edulists.com.au] <B>On Behalf
Of </B>Andrew Grimshaw<BR><B>Sent:</B> Tuesday, 31 May 2005 10:11
AM<BR><B>To:</B> Year 12 Information Technology Processing and Management
Teachers'MailingList<BR><B>Subject:</B> [Year 12 IPM] excel
merge<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>hi </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>i hope this is not too silly a
question</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>im trying to get excel to do something fairly
simple but i keep coming unstuck</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>i want it to insert a name from a colum into a
line of text</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>a simple cell reference will insert the name but
as soon as u add other text u get an error message</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2> (see attached screen dump)</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>any ideas out there?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>-andrew grimshaw</FONT></DIV>
<P></P>
<P><B>Important - </B>This email and any attachments may be confidential. If
received in error, please contact us and delete all copies. Before opening or
using attachments check them for viruses and defects. Regardless of any loss,
damage or consequence, whether caused by the negligence of the sender or not,
resulting directly or indirectly from the use of any attached files our
liability is limited to resupplying any affected attachments. Any
representations or opinions expressed are those of the individual sender, and
not necessarily those of the Department of Education &
Training._______________________________________________ <BR><A
href="http://www.edulists.com.au">http://www.edulists.com.au </A>- FAQ,
resources, subscribe, unsubscribe <BR>IPM Mailing List kindly supported by
<BR><A href="http://www.vcaa.vic.edu.au">http://www.vcaa.vic.edu.au </A>-
Victorian Curriculum and Assessment Authority and <BR><A
href="http://www.vitta.org.au">http://www.vitta.org.au </A>- VITTA Victorian
Information Technology Teachers Association Inc </P></BLOCKQUOTE><p></p><p><b>Important - </b>This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education & Training.</BODY></HTML>