View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Astro Astro is offline
external usenet poster
 
Posts: 9
Default Display only n numbers of characters for long text?

Hi everyone, I would like to find out whether can the following be done?

A1 cell with the information: abcdefghijklmno

For cell B2, I would like only to see n=5 of characters in A1, which will be
abcde?

How to link these 2 cells so that cell B2 will only show me first 5
characters of the long text I keyed in?

Please help....
Thank you.
Best Regards...