Need to use only 14 characters in cell
 

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?

Need to use only 14 characters in cell
 

Try this:

Select the column of text values

From the Excel Main Menu:
<data<text-to-columns
Check: Fixed Width.....Click: [Next]
Insert a breakpoint after character 14 (by clicking there).....Click: [Next]
Click on the 2nd column......Check: Do not import column
Click [Finish]

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Susie" wrote in message
...
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?

Need to use only 14 characters in cell
 

Yes, it worked. Spent hours trying different things....just didn't ask the
right group. Thanks for your help

"Ron Coderre" wrote:

Try this:

Select the column of text values

From the Excel Main Menu:
<data<text-to-columns
Check: Fixed Width.....Click: [Next]
Insert a breakpoint after character 14 (by clicking there).....Click: [Next]
Click on the 2nd column......Check: Do not import column
Click [Finish]

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Susie" wrote in message
...
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?