<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Century Gothic";
panose-1:2 11 5 2 2 2 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
p.preheader-container, li.preheader-container, div.preheader-container
{mso-style-name:preheader-container;
margin:0in;
margin-bottom:.0001pt;
mso-line-height-alt:.75pt;
font-size:1.0pt;
font-family:"Times New Roman",serif;
display:none;}
span.line
{mso-style-name:line;}
span.grabber
{mso-style-name:grabber;}
span.footer-column
{mso-style-name:footer-column;}
span.footer-mobile-hidden
{mso-style-name:footer-mobile-hidden;}
span.EmailStyle23
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:24184450;
mso-list-template-ids:-1128916556;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l0:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l1
{mso-list-id:385179786;
mso-list-template-ids:-1397095138;}
@list l1:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l1:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l1:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l1:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l1:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l1:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l1:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l1:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l2
{mso-list-id:513228138;
mso-list-template-ids:2078808738;}
@list l2:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l2:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l2:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l2:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l2:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l2:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l2:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l2:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l2:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l3
{mso-list-id:585656861;
mso-list-template-ids:719635824;}
@list l3:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l3:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l3:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l3:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l3:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l3:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l3:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l3:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l3:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l4
{mso-list-id:2074886926;
mso-list-template-ids:1686793324;}
@list l4:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l4:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l4:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l4:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l4:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l4:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l4:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l4:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l4:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body bgcolor="whitesmoke" lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">Greetings!<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">The Tech-Talk e-newsletter for Oregon library workers is distributed weekly via the Libs-OR and TechTalk mailing lists. Please do not forward.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">Know someone who might be interested in receiving a copy but they’re not on Libs-OR? Have them contact
<a href="mailto:darci.hanning@state.or.us">darci.hanning@state.or.us</a> or visit
<a href="http://listsmart.osl.state.or.us/mailman/listinfo/techtalk">http://listsmart.osl.state.or.us/mailman/listinfo/techtalk</a> to subscribe just to the newsletter!<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal" align="center" style="text-align:center"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">This paid subscription service is supported in whole by the Institute of Museum and Library Services (IMLS) through the Library
Services and Technology Act (LSTA), administered by the State Library of Oregon. Enjoy!<o:p></o:p></span></b></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse">
<tbody>
<tr>
<td style="padding:0in 0in 0in 0in">
<div>
<p class="MsoNormal" style="mso-line-height-alt:.75pt"><span style="font-size:1.0pt"><img border="0" id="_x0000_i1025" src="http://r20.rs6.net/on.jsp?ca=a781a711-1894-4369-982c-1756ebb932c2&a=1100778316270&c=980e0ed0-0713-11e6-a7b7-d4ae528ed502&ch=981cb4d0-0713-11e6-a7b7-d4ae528ed502"><o:p></o:p></span></p>
</div>
</td>
</tr>
<tr>
<td style="padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;background:whitesmoke;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td style="padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="0" style="width:459.0pt;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:11.25pt 3.75pt 11.25pt 3.75pt">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse">
<tbody>
<tr>
<td valign="top" style="background:#478CCB;padding:.75pt .75pt .75pt .75pt">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;background:#478CCB;border-collapse:collapse">
<tbody>
<tr>
<td valign="top" style="background:white;padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 0in 7.5pt 0in">
<div>
<p class="MsoNormal" align="center" style="text-align:center"><img border="0" width="220" id="_x0000_i1026" src="http://files.constantcontact.com/ee1208b4001/34916cb2-412f-43fa-8294-1f7ecb0e9a3d.png"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;background:#BFBFBF;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<p class="MsoNormal" align="center" style="text-align:center"><span style="color:#333333"> </span><b><span style="font-size:8.5pt;font-family:"Arial",sans-serif;color:white">Want to share Tech-Talk? Ask first. Contact
</span></b><span style="color:#333333"><a href="mailto:info@tech-talk.com" target="_blank"><b><span style="font-size:8.5pt;font-family:"Arial",sans-serif;color:white">info@Tech-Talk.com</span></b></a>
</span><b><span style="font-size:8.5pt;font-family:"Arial",sans-serif;color:white">© 2017 Shared Results International</span></b><span style="color:#333333"><o:p></o:p></span></p>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<div>
<p class="MsoNormal"><b><span style="font-family:"Arial",sans-serif;color:#333333">Brought to you by the State Library of Oregon</span></b><span style="color:#333333"><o:p></o:p></span></p>
</div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="right" style="border-collapse:collapse;margin-right:3.5pt;word-wrap: break-word">
<tbody>
<tr style="height:.75pt">
<td width="15" valign="top" style="width:11.25pt;padding:0in 0in 0in 0in;height:.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="15" height="1" id="_x0000_i1027" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
<td valign="top" style="padding:0in 0in 0in 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center"><img border="0" width="125" id="_x0000_i1028" src="http://files.constantcontact.com/ee1208b4001/9975e68c-5234-456e-bd40-fe203e94bf80.png" alt="State of Oregon"><o:p></o:p></p>
</div>
</td>
</tr>
<tr style="height:3.75pt">
<td width="15" valign="top" style="width:3.75pt;padding:0in 0in 0in 0in;height:3.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1029" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
<td valign="top" style="padding:0in 0in 0in 0in;height:3.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="1" height="5" id="_x0000_i1030" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</td>
<div>
<div>
<div>
<p class="MsoNormal"><span style="color:#333333">The State Library is pleased to provide you with Tech-Talk.com. We encourage you to make the most of this skill-building membership site at <a href="http://r20.rs6.net/tn.jsp?f=001z-L14VKrpGT3wXyUb3kjhojbFRQTkLUSMlva5jp3EAvaTFFB8N9mLNfUtILeVGaNm1LnnKTk_YGVYoRFD-Gd2__02YOj_RdgxO7TbgG3BJCwOFcGfrsOqWBxeMXoB3A4SpymUoEbhfyB0af0Zz1a7w==&c=B3GmVC1x6I-gvcco3WhBNcWDcL_D0dYZ0a-pmchJA9yTcUasg45ECA==&ch=nEMELESlPLGIUrW87YmgQnVIEQPoqru65m6Ehli2lKjnua2WSm07GA==" target="_blank"><span style="color:#0078C1">www.Tech-Talk.com</span></a>.
<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="color:#333333">Username</span></b><span style="color:#333333">: ORLIBTECH<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="color:#333333">Password</span></b><span style="color:#333333">: ORLIBTECH (case sensitive) <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333">Contact Darci Hanning at <a href="mailto:darci.hanning@state.or.us" target="_blank"><span style="color:#3300FF">darci.hanning@state.or.us</span></a> if you have questions.</span><span style="font-family:"Arial",sans-serif;color:#333333"> </span><span style="color:#333333"><o:p></o:p></span></p>
</div>
</div>
</div>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p>
<p></p>
<div align="center"></div>
</p>
</tr>
</tbody>
</table>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%;cursor:default">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:3.75pt 0in 3.75pt 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr style="height:.75pt">
<td style="background:#478CCB;padding:0in 0in 4.5pt 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1031" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 0in 7.5pt 0in">
<div>
<p class="MsoNormal" align="center" style="text-align:center"><a href="http://r20.rs6.net/tn.jsp?f=001z-L14VKrpGT3wXyUb3kjhojbFRQTkLUSMlva5jp3EAvaTFFB8N9mLHaA5V-zMJ4oEzH6J6wfzM62tKRkDAvMBS4FR7DW4-zl90c-Qg7WiW2YI_rSkNTW0LExHF4wG5TG164TQcZHTHnZu6El_WMXpt92orFFz-Q2ZIq78EuFd2Az_WwxOL3eavbDtv7D9-UeUlGz3axbX-E=&c=B3GmVC1x6I-gvcco3WhBNcWDcL_D0dYZ0a-pmchJA9yTcUasg45ECA==&ch=nEMELESlPLGIUrW87YmgQnVIEQPoqru65m6Ehli2lKjnua2WSm07GA=="><span style="text-decoration:none"><img border="0" width="521" id="_x0000_i1032" src="http://files.constantcontact.com/ee1208b4001/9763e732-f4c8-421c-adac-fd34a127f046.png"></span></a><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<div>
<p class="MsoNormal"><span style="color:#333333"> </span><b><span style="font-size:13.5pt;font-family:"Arial",sans-serif;color:#333333">This Week's Tech-Talk: EXCEL</span></b><span style="color:#333333"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="color:#3661BD">1. VIDEO ...</span></b><b><span style="color:#333333"> </span></b><span style="color:#333333">
<b>Easy Way to Change All Cap Text </b><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="color:#3661BD">2. ARTICLE ...</span></b><b><span style="color:#333333"> Easy Way to Change All Cap Text</span></b><span style="color:#333333"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="color:#3661BD">3. COMMUNICATING ...</span></b><b><span style="color:#333333"> "You're funny!"</span></b><span style="color:#333333"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="color:#333333">NOTE: To view the VIDEO, </span>
</b><span style="color:#333333"><a href="http://r20.rs6.net/tn.jsp?f=001z-L14VKrpGT3wXyUb3kjhojbFRQTkLUSMlva5jp3EAvaTFFB8N9mLHaA5V-zMJ4oEzH6J6wfzM62tKRkDAvMBS4FR7DW4-zl90c-Qg7WiW2YI_rSkNTW0LExHF4wG5TG164TQcZHTHnZu6El_WMXpt92orFFz-Q2ZIq78EuFd2Az_WwxOL3eavbDtv7D9-UeUlGz3axbX-E=&c=B3GmVC1x6I-gvcco3WhBNcWDcL_D0dYZ0a-pmchJA9yTcUasg45ECA==&ch=nEMELESlPLGIUrW87YmgQnVIEQPoqru65m6Ehli2lKjnua2WSm07GA==" target="_blank"><b><span style="color:#0078C1">click
here</span></b></a><b>. Enter the User Name and Password!</b><o:p></o:p></span></p>
</div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%;cursor:default">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:3.75pt 0in 3.75pt 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr style="height:.75pt">
<td style="background:#478CCB;padding:0in 0in 4.5pt 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1033" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<div>
<p class="MsoNormal"><b><span style="font-size:15.0pt;font-family:"Arial",sans-serif;color:#3661BD">Tech-Talk: EXCEL - Easy Way to Change All Cap Text</span></b><span style="color:#333333"><o:p></o:p></span></p>
</div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="right" style="border-collapse:collapse;margin-right:3.5pt;word-wrap: break-word">
<tbody>
<tr style="height:.75pt">
<td width="15" valign="top" style="width:11.25pt;padding:0in 0in 0in 0in;height:.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="15" height="1" id="_x0000_i1034" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
<td valign="top" style="padding:0in 0in 0in 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center"><img border="0" width="275" id="_x0000_i1035" src="http://files.constantcontact.com/ee1208b4001/c18e3ff2-aa4d-45c3-a9b9-c853ef8c1bc0.png" alt="All caps"><o:p></o:p></p>
</div>
</td>
</tr>
<tr style="height:3.75pt">
<td width="15" valign="top" style="width:3.75pt;padding:0in 0in 0in 0in;height:3.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1036" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
<td valign="top" style="padding:0in 0in 0in 0in;height:3.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="1" height="5" id="_x0000_i1037" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</td>
<div>
<div>
<div>
<p class="MsoNormal"><span style="color:#333333">What a day ... and a pleasant surprise ... I had last week!<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="color:#333333">There I was with a spreadsheet of over 300 entries that needed to be cleaned up for an online mail-merge.</span></b><span style="color:#333333"> We wanted to personalize each letter with the individual's name.
The problem was that the data was in ALL CAPS.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333">Who wants to see, "DEAR MR. POTTSWORTHY"? Clearly I have to re-type all 300 names into
<i>title case /</i> <i>proper case </i>- with just the first letter capitalized. Boy, that will be time consuming!<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333">Then I remember there is <b>a <i>
change case</i> option </b>...<b> but when I go looking for it in EXCEL ... it isn't there.</b> Urg! Am I really going to have to hand-type all of the 300+ names manually?<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333">Well, after a little digging, I find that
<b>changing text case IS possible in Excel -- but you have to use a <i>Formula</i>.</b> (Of course -- in Excel there's a formula for everything!)<o:p></o:p></span></p>
</div>
</div>
</div>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p>
<p></p>
<div align="center"></div>
</p>
</tr>
</tbody>
</table>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%;cursor:default">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:3.75pt 0in 3.75pt 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="93%" style="width:93.0%;border-collapse:collapse;min-width: 93%">
<tbody>
<tr style="height:.75pt">
<td style="background:#478CCB;padding:0in 0in 1.5pt 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1038" src="https://imgssl.constantcontact.com/letters/images/1101116784221/S.gif"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<div>
<p class="MsoNormal"><b><span style="font-family:"Arial",sans-serif;color:#478CCB">Change Case in Excel With This Formula</span></b><span style="color:#333333"><o:p></o:p></span></p>
</div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<div>
<p class="MsoNormal"><span style="color:#333333">When you have cells that contain text in all CAPS or lowercase, you can use a
<i>function</i> to change the text case to either UPPER, lower or Proper case (the first letter capitalized). It's not as simple in Excel as it is in Word. There’s 3 basic steps.<o:p></o:p></span></p>
</div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
<div>
<p class="MsoNormal"><span style="display:none"><o:p> </o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt;word-wrap: break-word">
<div>
<div>
<div>
<p class="MsoNormal"><b><span style="color:#333333">1. Add a Column</span></b><span style="color:#333333"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333">First, <i>add a temporary column
</i>next to the one that has the text in it that you would like to change the case.<o:p></o:p></span></p>
</div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 0in 7.5pt 0in">
<div>
<p class="MsoNormal" align="center" style="text-align:center"><img border="0" width="327" id="_x0000_i1039" src="http://files.constantcontact.com/ee1208b4001/e8eaf512-0382-477f-8098-b6f08b622975.png" alt="add a column"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<div>
<p class="MsoNormal"><b><span style="color:#333333">2. Enter the Formula</span></b><span style="color:#333333"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333">In the first cell of the empty column you're going to
<b>add a formula</b> that refers to the cell next to it (the one with all caps in this case).<o:p></o:p></span></p>
</div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="right" style="border-collapse:collapse;margin-right:3.5pt;word-wrap: break-word">
<tbody>
<tr style="height:.75pt">
<td width="15" valign="top" style="width:11.25pt;padding:0in 0in 0in 0in;height:.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="15" height="1" id="_x0000_i1040" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
<td valign="top" style="padding:0in 0in 0in 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center"><img border="0" width="309" id="_x0000_i1041" src="http://files.constantcontact.com/ee1208b4001/575efe0c-9355-4f4c-aa3e-10f589ebfd58.png"><o:p></o:p></p>
</div>
</td>
</tr>
<tr style="height:3.75pt">
<td width="15" valign="top" style="width:3.75pt;padding:0in 0in 0in 0in;height:3.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1042" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
<td valign="top" style="padding:0in 0in 0in 0in;height:3.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="1" height="5" id="_x0000_i1043" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</td>
<div>
<div>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l2 level1 lfo1">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span style="color:#333333">Type in the formula =PROPER(A2) and press
<i>Enter</i>.<o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l0 level1 lfo2">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span style="color:#333333">The new column will contain the text in your A2 cell, but in
<i>Proper </i>case.<o:p></o:p></span></p>
</div>
</div>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l4 level1 lfo3">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span style="color:#333333">To apply this formula to the whole column of cells in your spreadsheet,
<i>select the cell B2,</i> then grab the lower right corner of the cell when it is displaying a small square (that turns into a + sign) and
<i>drag it down the column of cells</i> to copy the formula to all cells.<o:p></o:p></span></p>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:0in 0in 0in 0in">
<div>
<p class="MsoNormal" align="center" style="text-align:center"><img border="0" width="294" id="_x0000_i1044" src="http://files.constantcontact.com/ee1208b4001/00aadd63-6485-4354-833c-6af82412c4fd.png" alt="drag it down"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<div>
<p class="MsoNormal"><b><span style="color:#333333">TIP:</span></b><span style="color:#333333"> In this example, the cell A2 is the first in our list that we want to convert. Of course in your spreadsheet it may not be cell A2, so add the cell reference appropriately.<o:p></o:p></span></p>
</div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<div>
<p class="MsoNormal"><b><span style="color:#333333">3. Copy the Column Contents</span></b><span style="color:#333333"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333">Now you have a column of text changed to the case you want. Since this column is actually filled with a
<i>formula</i>, not the text itself, you can't just delete the first column with the text in all caps to get rid of it -- or you will get formula errors.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l3 level1 lfo4">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span style="color:#333333">Instead, highlight the column of content with the
<i>new</i> proper case text, right-click and choose <i>copy</i>.<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l3 level1 lfo4">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span style="color:#333333">Now highlight column A column, right-click and choose
<i>Paste Special</i>, then <i>Paste Special</i> from the bottom of the window.<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l3 level1 lfo4">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span style="color:#333333">Choose to paste the <i>
Values</i> so that it just brings over the text of the cell, not the formula.<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l3 level1 lfo4">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span style="color:#333333">Now you can delete the temporary column.<o:p></o:p></span></p>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<div>
<p class="MsoNormal"><span style="color:#333333">In this example we changed all CAPS to Proper case (first letter in caps), but if you want to change text case to lower or upper case you would use the formulas: LOWER(A2) or UPPER(A2).<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="color:#333333">TIP</span></b><span style="color:#333333">: This formula might not stick in your brain, but remember you can always go to the
<a href="http://r20.rs6.net/tn.jsp?f=001z-L14VKrpGT3wXyUb3kjhojbFRQTkLUSMlva5jp3EAvaTFFB8N9mLNfUtILeVGaNm1LnnKTk_YGVYoRFD-Gd2__02YOj_RdgxO7TbgG3BJCwOFcGfrsOqWBxeMXoB3A4SpymUoEbhfyB0af0Zz1a7w==&c=B3GmVC1x6I-gvcco3WhBNcWDcL_D0dYZ0a-pmchJA9yTcUasg45ECA==&ch=nEMELESlPLGIUrW87YmgQnVIEQPoqru65m6Ehli2lKjnua2WSm07GA==" target="_blank">
<span style="color:#0078C1">www.Tech-Talk.com</span></a> database to find it when you need it later.<o:p></o:p></span></p>
</div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%;cursor:default">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:3.75pt 0in 3.75pt 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="93%" style="width:93.0%;border-collapse:collapse;min-width: 93%">
<tbody>
<tr style="height:.75pt">
<td style="background:#478CCB;padding:0in 0in 1.5pt 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1045" src="https://imgssl.constantcontact.com/letters/images/1101116784221/S.gif"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<div>
<p class="MsoNormal"><b><span style="font-family:"Arial",sans-serif;color:#478CCB">A Trick for Excel ... But Using Word</span></b><span style="color:#333333"><o:p></o:p></span></p>
</div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<div>
<p class="MsoNormal"><span style="color:#333333">Since Microsoft Word <i>does </i>
have a <i>change case</i> option, you may be able to use a shortcut of copy and paste between the software programs.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333">If the text that you want to convert is pretty straight forward (not hundreds or thousands of rows long), try this:<o:p></o:p></span></p>
</div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="right" style="border-collapse:collapse;margin-right:3.5pt;word-wrap: break-word">
<tbody>
<tr style="height:.75pt">
<td width="15" valign="top" style="width:11.25pt;padding:0in 0in 0in 0in;height:.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="15" height="1" id="_x0000_i1046" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
<td valign="top" style="padding:0in 0in 0in 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center"><img border="0" width="273" id="_x0000_i1047" src="http://files.constantcontact.com/ee1208b4001/a6987ad6-a9cc-4142-9c4c-d3c0eaa85abb.png" alt="copy to Word"><o:p></o:p></p>
</div>
</td>
</tr>
<tr style="height:3.75pt">
<td width="15" valign="top" style="width:3.75pt;padding:0in 0in 0in 0in;height:3.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1048" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
<td valign="top" style="padding:0in 0in 0in 0in;height:3.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="1" height="5" id="_x0000_i1049" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</td>
<div>
<div>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l1 level1 lfo5">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><i><span style="color:#333333">Copy </span></i><span style="color:#333333">the column of text you want to convert in Excel.<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l1 level1 lfo5">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><i><span style="color:#333333">Paste</span></i><span style="color:#333333"> it into a new Word document.<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l1 level1 lfo5">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span style="color:#333333">Use the <i>Change Case</i> option in the
<i>Font </i>section of the ribbon to make your changes.<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l1 level1 lfo5">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><i><span style="color:#333333">Copy </span></i><span style="color:#333333">the text from Word and
<i>Paste </i>it back into your Excel document.<o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333">This method is much more intuitive and easy to remember, but may be cumbersome with large amounts of content.<o:p></o:p></span></p>
</div>
</div>
</div>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%;cursor:default">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:3.75pt 0in 3.75pt 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr style="height:.75pt">
<td style="background:#478CCB;padding:0in 0in 4.5pt 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1050" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="left" style="border-collapse:collapse;margin-right:3.5pt;word-wrap: break-word">
<tbody>
<tr style="height:.75pt">
<td valign="top" style="padding:0in 0in 0in 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center"><img border="0" width="180" id="_x0000_i1051" src="http://files.constantcontact.com/ee1208b4001/f8f1ecc8-4884-4c21-8ed0-cf647e6db944.png"><o:p></o:p></p>
</div>
</td>
<td width="15" valign="top" style="width:11.25pt;padding:0in 0in 0in 0in;height:.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="15" height="1" id="_x0000_i1052" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
</tr>
<tr style="height:.75pt">
<td valign="top" style="padding:0in 0in 0in 0in;height:.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="1" height="5" id="_x0000_i1053" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
<td width="15" valign="top" style="width:3.75pt;padding:0in 0in 0in 0in;height:.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1054" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</td>
<div>
<div>
<div>
<p class="MsoNormal"><b><span style="font-size:13.5pt;font-family:"Arial",sans-serif;color:#333333">Communicating: Talking</span></b><span style="color:#333333"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><i><span style="color:#333333">Dismiss with "You're funny"</span></i><span style="color:#333333"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333">Let's say you're talking with someone and
<b>you simply don't know what to say </b>... it's an awkward situation because you don't wish to agree, and yet disagreeing would cause a problem.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="color:#333333">How do you get out of it gracefully?
</span></b><span style="color:#333333">Sometimes people are upset and you want to diffuse the situation instead of delving into it. You want to dismiss it.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="color:#333333">Try saying (with a pleasant smile), "You're funny!"</span></b><span style="color:#333333"> and then move on. This way the person doesn't think you're making fun of them ... or their idea. They're just slightly
confused, because you think they're being funny. No one gets upset about that.<o:p></o:p></span></p>
</div>
</div>
</div>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%;cursor:default">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:3.75pt 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr style="height:.75pt">
<td style="background:#478CCB;padding:0in 0in 4.5pt 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1055" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;background:#E8E8E8;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 0in 7.5pt 0in">
<div>
<p class="MsoNormal" align="center" style="text-align:center"><img border="0" width="600" id="_x0000_i1056" src="http://files.constantcontact.com/ee1208b4001/9aa120ac-150c-4f0d-9bbd-dc5dbd2f0179.png" alt="innovation"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;background:#E8E8E8;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<p class="MsoNormal" align="center" style="text-align:center"><span style="color:#333333"> <a href="http://r20.rs6.net/tn.jsp?f=001z-L14VKrpGT3wXyUb3kjhojbFRQTkLUSMlva5jp3EAvaTFFB8N9mLNfUtILeVGaNm1LnnKTk_YGVYoRFD-Gd2__02YOj_RdgxO7TbgG3BJCwOFcGfrsOqWBxeMXoB3A4SpymUoEbhfyB0af0Zz1a7w==&c=B3GmVC1x6I-gvcco3WhBNcWDcL_D0dYZ0a-pmchJA9yTcUasg45ECA==&ch=nEMELESlPLGIUrW87YmgQnVIEQPoqru65m6Ehli2lKjnua2WSm07GA==" target="_blank"><span style="font-family:"Arial",sans-serif;color:#0078C1">CLICK
HERE ... FOR THE TECH-TALK LIBRARY!</span></a><o:p></o:p></span></p>
<p class="MsoNormal" align="center" style="text-align:center"><span style="font-family:"Arial",sans-serif;color:#333333">Your Membership Site! </span><span style="color:#333333"><o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="font-size:10.5pt;font-family:"Arial",sans-serif;color:#333333">NOTE:</span></b><span style="font-size:10.5pt;font-family:"Arial",sans-serif;color:#333333"> Forgot your user ID? See your sponsor block at the top of this email.</span><span style="color:#333333"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Arial",sans-serif;color:#333333">Problems? Contact us at
</span><span style="color:#333333"><a href="mailto:Support@Tech-Talk.com" target="_blank"><b><span style="font-size:10.5pt;font-family:"Arial",sans-serif;color:#0078C1">Support@Tech-Talk.com</span></b></a><o:p></o:p></span></p>
</div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%;cursor:default">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr style="height:.75pt">
<td style="background:#478CCB;padding:0in 0in 4.5pt 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1057" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="50%" valign="top" style="width:50.0%;background:#E8E8E8;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 7.5pt 7.5pt 15.0pt">
<div>
<div>
<p class="MsoNormal" align="center" style="text-align:center"><span style="font-size:10.5pt;color:#533907"> </span><span style="font-size:10.5pt;font-family:"Arial",sans-serif;color:#533907">Do you have an idea for an article, or a problem using technology
in some way...</span><span style="color:#333333"><o:p></o:p></span></p>
<p class="MsoNormal" align="center" style="text-align:center"><span style="color:#333333"><o:p> </o:p></span></p>
<p class="MsoNormal" align="center" style="text-align:center"><span style="font-size:13.5pt;font-family:"Tahoma",sans-serif;color:#E6092E"></span><b><span style="font-size:13.5pt;font-family:"Arial",sans-serif;color:#BF3F2F">We can help! </span></b><span style="color:#333333"><o:p></o:p></span></p>
<p class="MsoNormal" align="center" style="text-align:center"><b><span style="font-size:13.5pt;font-family:"Tahoma",sans-serif;color:#BF3F2F"></span></b><span style="color:#333333"><o:p></o:p></span></p>
<p class="MsoNormal" align="center" style="text-align:center"><b><span style="font-size:10.5pt;font-family:"Arial",sans-serif;color:#4C4C4C">Just contact us and we'll get the answer for you right away.
</span></b><span style="color:#333333"><a href="http://r20.rs6.net/tn.jsp?f=001z-L14VKrpGT3wXyUb3kjhojbFRQTkLUSMlva5jp3EAvaTFFB8N9mLF0EiylYeJSHR4L1HA4ZzwLwpLZeYhW-AMUDhZ3ydaFdTToqGeEv5xchfqnqqkNG37X4G5LcClUIeYLxlUjU9N8AoHHX1yXrnkYXdUgPXBrH7Nt-gPITvCQ=&c=B3GmVC1x6I-gvcco3WhBNcWDcL_D0dYZ0a-pmchJA9yTcUasg45ECA==&ch=nEMELESlPLGIUrW87YmgQnVIEQPoqru65m6Ehli2lKjnua2WSm07GA==" target="_blank"><b><span style="font-size:10.5pt;font-family:"Arial",sans-serif;color:#4C4C4C">Click
here</span></b></a></span><b><span style="font-size:10.5pt;font-family:"Arial",sans-serif;color:#4C4C4C">!</span></b><span style="font-size:10.5pt;color:#4C4C4C"> </span><span style="color:#333333"><o:p></o:p></span></p>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
<td width="50%" valign="top" style="width:50.0%;background:#E8E8E8;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:0in 15.0pt 0in 7.5pt">
<div>
<p class="MsoNormal" align="right" style="text-align:right"><img border="0" width="233" id="_x0000_i1058" src="http://files.constantcontact.com/ee1208b4001/464c50f5-0d77-4705-bb24-bf95437ce585.jpg"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#1F497D">Copyright 1996-2017 Shared Results International. Published weekly. Do not forward this issue of Tech-Talk.com without prior permission from Shared Results International.
Distribution is limited by contract. Forwarding it to unauthorized recipients constitutes copyright infringement. For information on site licenses or how to include additional recipients, email
<a href="mailto:darci.hanning@state.or.us">darci.hanning@state.or.us</a>.</span><span style="color:#333333"><o:p></o:p></span></p>
</div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</div>
<div></div>
<div></div>
<div></div>
<div></div>
<div></div>
<div></div>
<div></div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Cheers,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal" style="margin-bottom:3.0pt"><b><span style="font-size:10.0pt;font-family:"Century Gothic",sans-serif;color:black">Darci Hanning, MLIS<o:p></o:p></span></b></p>
<p class="MsoNormal" style="margin-bottom:3.0pt;line-height:115%"><span style="font-size:9.0pt;line-height:115%;font-family:"Calibri",sans-serif;color:#1F497D">Technology Development Consultant</span><span style="font-size:9.0pt;line-height:115%;font-family:"Calibri",sans-serif;color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal" style="margin-bottom:3.0pt;line-height:115%"><span style="font-size:9.0pt;line-height:115%;font-family:"Calibri",sans-serif;color:#2E74B5"><a href="mailto:darci.hanning@state.or.us"><span style="color:#2E74B5">darci.hanning@state.or.us</span></a></span><span style="font-size:9.0pt;line-height:115%;font-family:"Calibri",sans-serif;color:#1F497D">
<b>|</b> 503-378-2527 <b>|</b></span><span style="font-size:9.0pt;line-height:115%;font-family:"Calibri",sans-serif;color:#2E74B5">
<a href="http://www.oregon.gov/osl/ld"><span style="color:#2E74B5">www.oregon.gov/osl/ld</span></a></span><span style="font-size:9.0pt;line-height:115%;font-family:"Calibri",sans-serif;color:#1F497D">
</span><u><span style="font-size:9.0pt;line-height:115%;font-family:"Calibri",sans-serif;color:#0563C1"><o:p></o:p></span></u></p>
<p class="MsoNormal" style="margin-bottom:3.0pt"><span style="font-size:9.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Follow us:
</span><span style="font-size:9.0pt;font-family:"Calibri",sans-serif;color:#2E74B5"><a href="http://fb.me/orlibsupport"><span style="color:#2E74B5">Facebook</span></a></span><span style="font-size:9.0pt;font-family:"Calibri",sans-serif;color:#1F497D">
<b>|</b> </span><span style="font-size:9.0pt;font-family:"Calibri",sans-serif;color:#2E74B5"><a href="https://twitter.com/ORLibSupport"><span style="color:#2E74B5">Twitter</span></a></span><b><span style="font-size:9.0pt;font-family:"Calibri",sans-serif;color:#1F497D">
|</span></b><span style="font-size:9.0pt;font-family:"Calibri",sans-serif;color:#1F497D">
</span><span style="font-size:9.0pt;font-family:"Calibri",sans-serif;color:#2E74B5"><a href="http://www.statelibraryor.tumblr.com/"><span style="color:#2E74B5">Tumblr</span></a></span><b><span style="font-size:9.0pt;font-family:"Calibri",sans-serif;color:#1F497D">
| </span></b><span style="font-size:9.0pt;font-family:"Calibri",sans-serif;color:#2E74B5"><a href="https://pinterest.com/statelibraryor/"><span style="color:#2E74B5">Pinterest</span></a></span><u><span style="font-size:9.0pt;font-family:"Calibri",sans-serif;color:blue">
<o:p></o:p></span></u></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:9.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Ask me about the
</span><span style="font-size:9.0pt;font-family:"Calibri",sans-serif;color:#ED7D31"><a href="http://oregonedge.net/"><span style="color:#ED7D31">Edge Initiative</span></a></span><span style="font-size:9.0pt;font-family:"Calibri",sans-serif;color:#1F497D">!
</span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><img border="0" width="342" height="43" id="Picture_x0020_1" src="cid:image001.png@01D32C94.907EFE20" alt="cid:image005.png@01D31C27.4B9FEA30"><o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="display:none"><o:p> </o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div></div>
<div></div>
</body>
</html>