View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Darlie Mary[_2_] Darlie Mary[_2_] is offline
external usenet poster
 
Posts: 2
Default Use Len and Left to make name 3 letters

The last name is in Column C and the first name is in Column A. I need to
make a new column with the first 3 letters of the last name. If the last name
is 2 letters, the last letter needs to be a Z. (Example: Bo, it needs to be
BoZ). Also need to add the first initial of the first name.