Is there a way in Excel to limit the number of characters in a cell? Thanks Frank
F Frankc Aug 10, 2005 #1 Is there a way in Excel to limit the number of characters in a cell? Thanks Frank
D David McRitchie Aug 10, 2005 #2 By checking the length of the cell =LEN(A1)=2 in your custom validation. Look for Data Validation on Debra Dalgleish's site.
By checking the length of the cell =LEN(A1)=2 in your custom validation. Look for Data Validation on Debra Dalgleish's site.
E ellmcg Aug 11, 2005 #3 You can do it directly, using Data --> Validation, and choosing text length. David McRitchie said: By checking the length of the cell =LEN(A1)=2 in your custom validation. Look for Data Validation on Debra Dalgleish's site. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm Frankc said: Is there a way in Excel to limit the number of characters in a cell? Thanks Frank Click to expand... Click to expand...
You can do it directly, using Data --> Validation, and choosing text length. David McRitchie said: By checking the length of the cell =LEN(A1)=2 in your custom validation. Look for Data Validation on Debra Dalgleish's site. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm Frankc said: Is there a way in Excel to limit the number of characters in a cell? Thanks Frank Click to expand... Click to expand...
