formatting - How to set a character limit and remove characters over that limit excel 2007 - Super U

I have to provide a CSV file for a telephone system with names and numbers on for a directory. The numbers cannot contain any spaces, and the names must be 20 characters ...

superuser.com