Thread: How to use LEN & LEFT on last name to show only 3 letters
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Darlie Mary Darlie Mary is offline
external usenet poster
  
Posts: 1
Default How to use LEN & LEFT on last name to show only 3 letters
Need syntax to show first 3 letters of last name and first letter of first
name. Also if last name only has 2 letters, need to add a Z on end to make 3
letters.
Reply With QuoteReply With Quote