Hey All I have SURNAMES being entered into cells B7:B105 .. I am looking for code that will take the first letter entered and put it into cells C5:C107 So .. if B5=Johnson .. C5=J Is this possible? Can anyone help?