How can I automate the process of copying the first letter of a ce

Steve · Mar 28, 2007

So I have my students first names in column A and I want to show their first
name initial in colum B. And I need to do it for 180 students
Cheers
Steve

Max · Mar 28, 2007

Assuming names in A2 down
In B2: =LEFT(TRIM(A2))
Copy down

How can I automate the process of copying the first letter of a ce

Steve

Max