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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How can I automate the process of copying the first letter of a ce (https://www.excelbanter.com/excel-worksheet-functions/136795-how-can-i-automate-process-copying-first-letter-ce.html)

Steve

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

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

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

Assuming names in A2 down
In B2: =LEFT(TRIM(A2))
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Steve" wrote:
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

All times are GMT +1. The time now is 01:45 PM.