User profile for user: 4keeks
4keeks Author
User level: Level 1
0 points

Is there a way to set a limit on the number of characters each cell will hold in numbers?

Hi there, I'm creating a CSV file via Numbers and would like to set a limit to the number of characters a cell will hold in numbers. This way, when I copy text from my source, and paste it into the numbers cell, the text will be cut off at the character limit I've placed for that cell.


Specifically, I would like my character limit per cell in a column on a new spreadsheet to be 100 characters. I have text to copy & paste into roughly 10 different cells and I'd like it to all be 100 characters.


I am using Numbers version 9 of iWork and 10.7.5 OS.


Any help is appreciated.

MacBook, Mac OS X (10.7.5)

Posted on Sep 30, 2014 7:41 AM

Reply
9 replies
User profile for user: 4keeks
4keeks Author
User level: Level 1
0 points

Sep 30, 2014 8:37 AM in response to t quinn

Thank you t quinn for your reply as I do really appreciate the help.


I don't quite understand what your suggestion was and before I try to figure it out and play around with numbers, I thought I should clarify further. When i wrote I want to paste the content into the cell and have it limited to 100 characters I was mis-spoken. I actually have all the content already in the columns in a spreadsheet and would now like to just limit some of the columns to hold only 100 characters in a cell so that when its a CSV file it will be accepted to the program I'm trying to upload it to.


SO does that change the way you can answer my question?


Is there a way to just limit the content currently in a spreadsheet to 100 characters per cell?


Kindly

Reply
User profile for user: t quinn
t quinn
User level: Level 5
7,063 points

Sep 30, 2014 8:58 AM in response to 4keeks

Hi 4keeks,


There is still no way to limit the amount of text in a cell. You can still get waht you want.


We will change the way you will use the formula.

Create a new column, next to the column(s) you want to limit.

Use the same formula refering to the original column. Fill it down.

Select your new column, copy.

With the new column still selected, Menu>Edit>Paste Formula Results. This is where you change the formula to the 100 chars of text.

Delete your original column. If your 100 characters disappear, you did not do the above step correctly.

You should be good to go.


quinn

Reply

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Is there a way to set a limit on the number of characters each cell will hold in numbers?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.
Learn more Sign up