Thread: How can I automate the process of copying the first letter of a ce
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default 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
Reply With QuoteReply With Quote