View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Beege
 
Posts: n/a
Default LEN fuction to leave a single character

"Jonah" wrote in message
...
What is the LEN fuction to leave a single character from a text string.
I need the initial letter from a name and the last letter. How do i
join LEN fuctions togetehr into a single formula?

J
LEN fuction to leave a single character


Jonah,

Should be LEFT() or RIGHT() function


Beege