Formula Help

Manda_Panda

I have one column with a person's first name, then I have another column that I want to be just the first initial of the previous column's first person's name.

Instead of typing in the first initial every time, I want to know if there is a formula I can put in the initial column??

Chris McKay

Hi Manda,

Assuming I understand you correctly, you just want the first letter from your First Name column to appear in your First Initial column? If so, enter this formula in First Initial and copy down as far as required:

=LEFT([First Name]1,1)