Need to use only 14 characters in cell

  • Thread starter Thread starter Susie
  • Start date Start date
S

Susie

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?
 
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)
 
Yes, it worked. Spent hours trying different things....just didn't ask the
right group. Thanks for your help

Ron Coderre said:
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 said:
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?
Click to expand...
Click to expand...
 
Back
Top