discarn8

=LOWER(CONCATENATE(A2,".",B2))

discarn8

check for lowercase
=NOT(EXACT(UPPER(B1),B1))

discarn8

Check if the cell has a dn in it and if not - add it
=IF(C2=0,"",IF(ISNUMBER(SEARCH(C2,B2)),B2,B2&" "&C2)

discarn8

<!-- beginning of HttpRedirect.htm file --> 
<script type="text/javascript"> 
function redirectToHttps() 
{ 
var httpURL = window.location.hostname+window.location.pathname; 
var httpsURL = "https://" + httpURL ; 
window.location = httpsURL ; 
} 
redirectToHttps(); 
</script> 

discarn8

#! /bin/bash
#set -x
. /etc/profile
. ~/.bashrc


#CLEAR ANY OLD LOG FILES
#---------------------------------------------------------------------
cat /dev/null > /home/trapfile
#cat /dev/null > /tmp/trap.txt

discarn8

#!/bin/bash
NET=192.168.0
for n in $(seq 1 254); do
  ADDR=${NET}.${n}
  echo -e "${ADDR}\t$(dig -x ${ADDR} +short)"
done

discarn8

Public Sub Srch()
'-------------------------------------------------------------------------------------------------
'---Created by: Ryan Wells------------------------------------------------------------------------
'---Date: 03/2015---------------------------------------------------------------------------------
'---Program: OutlookSearch------------------------------------------------------------------------
'---Purpose: Search Outlook inbox for a particular string and display the results-----------------
'------------in a "Search Folders" folder.--------------------------------------------------------
'-------------------1) Make sure you have an email selected in your inbox.------------------------
'-------------------2) Press "Alt F8"-------------------------------------------------------------
'-------------------3) Select SearchString > Run--------------------------------------------------

discarn8

Sub QuickInfo()
    MsgBox "Message Line 1" & vbCrLf & "Message Line 2" _
    & vbCrLf & "Message Line 3" & vbCrLf & "Message Line 4" _
    & vbCrLf & "Message Line 5"
End Sub

discarn8

'This will search the beginning of your email messages for the 
' current year(you specify).  If it is not already there, the 
' script will add the current date / time to the beginning of
' your message subject.  Good for archiving messages by date / time

Public Sub datemod()
Dim oMailS As Outlook.MailItem
Dim MsgCount, MsgMatch, ErrCount As Integer
Dim ErrrMsg As String
Dim sstring, dstring

discarn8

Public Sub EXTREQ()
Dim oMail, oMailS As Outlook.MailItem
Dim Recip, first, last, rResult, dResult As String
Dim oFSO, oFS, bstring, cstring, sstring, rVar, lVar, fn, ln, rsVar, lsVar, test
Dim objAttach As Outlook.Attachment
Dim SentFrom As Outlook.NameSpace
Set SentFrom = Application.GetNamespace("MAPI")
Set objFolder = Application.ActiveExplorer.CurrentFolder.Items
Set colItems = objFolder