View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Astro Astro is offline
external usenet poster
 
Posts: 9
Default Limit to 5 characters...

Dear all,

Is there any ways to limit the number of alphabets you key in the cell and
move the to the next cell? For example if you enter "circular" which has 8
characters, is there a way such that:
A B C
1 circu
2 lar
3

Please help..... Thank you.