Is there a formula (or macros) that grabs the first character of a string of
text??

For example I have the following columns: Column A (Last name) Smith, Column
B (First name) Heather. In column C i want the first Character of Column B so
in this case it would be H.

Any suggestions? Thanks in advance