[Year 12 IPM] excel merge

[Lel, Ronald A]

You need to concatenate your student's name with the text you wish to
add - eg
=A3 & " Has worked well"
 
The ampersand is the concatenation operator; the text you wish to add
has to be in inverted commas.
 
Cheers
Ron Lel

	-----Original Message-----
	From: ipm-bounces at edulists.com.au
[mailto:ipm-bounces at edulists.com.au] On Behalf Of Andrew Grimshaw
	Sent: Tuesday, 31 May 2005 10:11 AM
	To: Year 12 Information Technology Processing and Management
Teachers'MailingList
	Subject: [Year 12 IPM] excel merge
	
	
	hi 
	 
	i hope this is not too silly a question
	 
	im trying to get excel to do something fairly simple but i keep
coming unstuck
	 
	i want it to insert a name from a colum into a line of text
	 
	a simple cell reference will insert the name but as soon as u
add other text u get an error message
	 
	 (see attached screen dump)
	 
	 
	any ideas out there?
	 
	-andrew grimshaw

	

	Important - 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._______________________________________________ 
	http://www.edulists.com.au - FAQ, resources, subscribe,
unsubscribe 
	IPM Mailing List kindly supported by 
	http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment
Authority and 
	http://www.vitta.org.au - VITTA Victorian Information Technology
Teachers Association Inc 



Important - 
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/ipm/attachments/20050531/700ffbcd/attachment.html