Home |
Search |
Today's Posts |
#1
|
|||
|
|||
limit number of characters in a cell
I am creating an application form to be used electronically. I want a
particular cell to be free text, so users can write what they like (ie their name), but I want to limit the number of characters they can use. Can this be done? I have put text wrap on the cell, but it still allows me to enter more information than fits into the box. I want it to stop users entering info when the visible cell is full. Rob, Teesside, UK. |
#2
|
|||
|
|||
"abfabrob" wrote: I am creating an application form to be used electronically. I want a particular cell to be free text, so users can write what they like (ie their name), but I want to limit the number of characters they can use. Can this be done? I have put text wrap on the cell, but it still allows me to enter more information than fits into the box. I want it to stop users entering info when the visible cell is full. Rob, Teesside, UK. |
#3
|
|||
|
|||
Hi Abfabrob,
Select the cell(s) you want to limit, let's assume A1 is to be limited to 10 char. Go to Data - Validation. Select "Formula" for the type. The formula would be as follows: =LEN(A1)<=10 You can copy and paste validation to other cells using paste special... Regards, Jon "abfabrob" wrote: I am creating an application form to be used electronically. I want a particular cell to be free text, so users can write what they like (ie their name), but I want to limit the number of characters they can use. Can this be done? I have put text wrap on the cell, but it still allows me to enter more information than fits into the box. I want it to stop users entering info when the visible cell is full. Rob, Teesside, UK. |
#4
|
|||
|
|||
Sorry, another note... Fiddle about with validation and you'll see that there
are other options available too. "abfabrob" wrote: I am creating an application form to be used electronically. I want a particular cell to be free text, so users can write what they like (ie their name), but I want to limit the number of characters they can use. Can this be done? I have put text wrap on the cell, but it still allows me to enter more information than fits into the box. I want it to stop users entering info when the visible cell is full. Rob, Teesside, UK. |
#5
|
|||
|
|||
Thank you for your help. I will give this a try.
Rob, Teesside, UK "Springbok" wrote: Sorry, another note... Fiddle about with validation and you'll see that there are other options available too. "abfabrob" wrote: I am creating an application form to be used electronically. I want a particular cell to be free text, so users can write what they like (ie their name), but I want to limit the number of characters they can use. Can this be done? I have put text wrap on the cell, but it still allows me to enter more information than fits into the box. I want it to stop users entering info when the visible cell is full. Rob, Teesside, UK. |
#6
|
|||
|
|||
There is no "formula" in the list in the settings tab under data validation.
I am probably doing this wrong! Does it make a difference which version of Excell I am using? (2000) "Springbok" wrote: Hi Abfabrob, Select the cell(s) you want to limit, let's assume A1 is to be limited to 10 char. Go to Data - Validation. Select "Formula" for the type. The formula would be as follows: =LEN(A1)<=10 You can copy and paste validation to other cells using paste special... Regards, Jon "abfabrob" wrote: I am creating an application form to be used electronically. I want a particular cell to be free text, so users can write what they like (ie their name), but I want to limit the number of characters they can use. Can this be done? I have put text wrap on the cell, but it still allows me to enter more information than fits into the box. I want it to stop users entering info when the visible cell is full. Rob, Teesside, UK. |
#7
|
|||
|
|||
There is no "formula" in the list in the settings tab under data validation.
I am probably doing this wrong! Does it make a difference which version of Excell I am using? (2000) "abfabrob" wrote: Thank you for your help. I will give this a try. Rob, Teesside, UK "Springbok" wrote: Sorry, another note... Fiddle about with validation and you'll see that there are other options available too. "abfabrob" wrote: I am creating an application form to be used electronically. I want a particular cell to be free text, so users can write what they like (ie their name), but I want to limit the number of characters they can use. Can this be done? I have put text wrap on the cell, but it still allows me to enter more information than fits into the box. I want it to stop users entering info when the visible cell is full. Rob, Teesside, UK. |
#8
|
|||
|
|||
Sorry, my mistake, it's "Custom". Xl 2000 definitely has it. Go Data -
Validation. In the settings tab there's a drop down list under "Allow:" Within that the final option is "Custom". Once selected a text box appears below, that's where the formula goes. "abfabrob" wrote: There is no "formula" in the list in the settings tab under data validation. I am probably doing this wrong! Does it make a difference which version of Excell I am using? (2000) "abfabrob" wrote: Thank you for your help. I will give this a try. Rob, Teesside, UK "Springbok" wrote: Sorry, another note... Fiddle about with validation and you'll see that there are other options available too. "abfabrob" wrote: I am creating an application form to be used electronically. I want a particular cell to be free text, so users can write what they like (ie their name), but I want to limit the number of characters they can use. Can this be done? I have put text wrap on the cell, but it still allows me to enter more information than fits into the box. I want it to stop users entering info when the visible cell is full. Rob, Teesside, UK. |
#9
|
|||
|
|||
Jon,
It totally worked! Thank you! Rob. "Springbok" wrote: Sorry, my mistake, it's "Custom". Xl 2000 definitely has it. Go Data - Validation. In the settings tab there's a drop down list under "Allow:" Within that the final option is "Custom". Once selected a text box appears below, that's where the formula goes. "abfabrob" wrote: There is no "formula" in the list in the settings tab under data validation. I am probably doing this wrong! Does it make a difference which version of Excell I am using? (2000) "abfabrob" wrote: Thank you for your help. I will give this a try. Rob, Teesside, UK "Springbok" wrote: Sorry, another note... Fiddle about with validation and you'll see that there are other options available too. "abfabrob" wrote: I am creating an application form to be used electronically. I want a particular cell to be free text, so users can write what they like (ie their name), but I want to limit the number of characters they can use. Can this be done? I have put text wrap on the cell, but it still allows me to enter more information than fits into the box. I want it to stop users entering info when the visible cell is full. Rob, Teesside, UK. |
#10
|
|||
|
|||
Hi Rob,
Another way is to use the Text Length option under Data Validation Settings Allow Text Length Choose the criteria you want Ok. HTH Regards, Howard "abfabrob" wrote in message ... I am creating an application form to be used electronically. I want a particular cell to be free text, so users can write what they like (ie their name), but I want to limit the number of characters they can use. Can this be done? I have put text wrap on the cell, but it still allows me to enter more information than fits into the box. I want it to stop users entering info when the visible cell is full. Rob, Teesside, UK. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a limit to number of words in a cell in excel? | Excel Discussion (Misc queries) | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
Can I limit a cell to 72 characters? How? | Excel Discussion (Misc queries) | |||
Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |