I have a large spreadsheet that will be imported by another program. It is
already complete and I discover that one column can only be 14 characters. I
have more. I have tried the Data/Validate and it doesn't 'chop off' the
unwanted characters. How do I do this?