{"id":12083,"date":"2011-11-10T18:18:45","date_gmt":"2011-11-10T18:18:45","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/?p=424"},"modified":"2011-11-10T18:18:45","modified_gmt":"2011-11-10T18:18:45","slug":"restrict-to-fixed-text-or-integer-length-in-the-given-range-of-cells","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2011\/11\/restrict-to-fixed-text-or-integer-length-in-the-given-range-of-cells\/","title":{"rendered":"Restrict to fixed text or integer length in the given range of cells"},"content":{"rendered":"<p>Follow below steps to Restrict to fixed text or integer length in the given range of cells:<\/p>\n<p>1. Select the Cell Range where you want to put the restriction<br \/>\n2. Go to &#8220;Data&#8221; Tab in Excel<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/11\/Data-Validation-1.png\" alt=\"Data Validation\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>3. Click on Data Validation Option and Select &#8220;Text Length&#8221; from the Drop down as show below:<br \/>\n<img decoding=\"async\" src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/11\/Data-Validation-2.png\" alt=\"Data Validation\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>3. Select the Data option as per your requirement<br \/>\n<img decoding=\"async\" src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/11\/Data-Validation-3.png\" alt=\"Data Validation\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>4. Now enter the accepted length for the characters to be entered in that cell range<br \/>\n<img decoding=\"async\" src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/11\/Data-Validation-4.png\" alt=\"Data Validation\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>5. Here you can cutomize your Error message also, what you want to display when the defined validation is violated:<br \/>\n<img decoding=\"async\" src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/11\/Data-Validation-5.png\" alt=\"Data Validation\" \/><\/p>\n<p>6. After violating the defined validation, following Error message will be displayed:<\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/11\/Data-Validation-6.png\" alt=\"Data Validation\" \/><\/p>\n<p>&nbsp;<\/p>\n<span class=\"et_bloom_bottom_trigger\"><\/span>","protected":false},"excerpt":{"rendered":"<p>Follow below steps to Restrict to fixed text or integer length in the given range of cells: 1. Select the Cell Range where you want to put the restriction 2. Go to &#8220;Data&#8221; Tab in Excel &nbsp; 3. Click on Data Validation Option and Select &#8220;Text Length&#8221; from the Drop down as show below: &nbsp; [&hellip;]<\/p>\n","protected":false},"author":45,"featured_media":431,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[1672,1673],"tags":[],"class_list":["post-12083","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-formula","category-excel-functions"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v23.5 (Yoast SEO v23.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Restrict to fixed text or integer length in the given range of cells - Let&#039;s excel in Excel<\/title>\n<meta name=\"description\" content=\"It is very easy to implement such validation. For this no VBA code required. It can be done just by using inbuilt functionality of Excel, which is called as Data Validation. Follow below steps to Restrict to fixed text or integer length in the given range of cells\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/vmlogger.com\/excel\/2011\/11\/restrict-to-fixed-text-or-integer-length-in-the-given-range-of-cells\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Restrict to fixed text or integer length in the given range of cells\" \/>\n<meta property=\"og:description\" content=\"It is very easy to implement such validation. For this no VBA code required. It can be done just by using inbuilt functionality of Excel, which is called as Data Validation. Follow below steps to Restrict to fixed text or integer length in the given range of cells\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/2011\/11\/restrict-to-fixed-text-or-integer-length-in-the-given-range-of-cells\/\" \/>\n<meta property=\"og:site_name\" content=\"Let&#039;s excel in Excel\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:author\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:published_time\" content=\"2011-11-10T18:18:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/vmlogger.com_-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Vishwamitra Mishra\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/www.twitter.com\/learnexcelmacro\" \/>\n<meta name=\"twitter:site\" content=\"@learnexcelmacro\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vishwamitra Mishra\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/11\/restrict-to-fixed-text-or-integer-length-in-the-given-range-of-cells\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/11\/restrict-to-fixed-text-or-integer-length-in-the-given-range-of-cells\/\"},\"author\":{\"name\":\"Vishwamitra Mishra\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"headline\":\"Restrict to fixed text or integer length in the given range of cells\",\"datePublished\":\"2011-11-10T18:18:45+00:00\",\"dateModified\":\"2011-11-10T18:18:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/11\/restrict-to-fixed-text-or-integer-length-in-the-given-range-of-cells\/\"},\"wordCount\":122,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/11\/restrict-to-fixed-text-or-integer-length-in-the-given-range-of-cells\/#primaryimage\"},\"thumbnailUrl\":\"\",\"articleSection\":[\"Excel Formula\",\"Excel Functions\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2011\/11\/restrict-to-fixed-text-or-integer-length-in-the-given-range-of-cells\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/11\/restrict-to-fixed-text-or-integer-length-in-the-given-range-of-cells\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/2011\/11\/restrict-to-fixed-text-or-integer-length-in-the-given-range-of-cells\/\",\"name\":\"Restrict to fixed text or integer length in the given range of cells - Let&#039;s excel in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/11\/restrict-to-fixed-text-or-integer-length-in-the-given-range-of-cells\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/11\/restrict-to-fixed-text-or-integer-length-in-the-given-range-of-cells\/#primaryimage\"},\"thumbnailUrl\":\"\",\"datePublished\":\"2011-11-10T18:18:45+00:00\",\"dateModified\":\"2011-11-10T18:18:45+00:00\",\"description\":\"It is very easy to implement such validation. For this no VBA code required. It can be done just by using inbuilt functionality of Excel, which is called as Data Validation. Follow below steps to Restrict to fixed text or integer length in the given range of cells\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/11\/restrict-to-fixed-text-or-integer-length-in-the-given-range-of-cells\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2011\/11\/restrict-to-fixed-text-or-integer-length-in-the-given-range-of-cells\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/11\/restrict-to-fixed-text-or-integer-length-in-the-given-range-of-cells\/#primaryimage\",\"url\":\"\",\"contentUrl\":\"\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/11\/restrict-to-fixed-text-or-integer-length-in-the-given-range-of-cells\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/vmlogger.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Formula\",\"item\":\"https:\/\/vmlogger.com\/excel\/excel-formula\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Restrict to fixed text or integer length in the given range of cells\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\",\"url\":\"https:\/\/vmlogger.com\/excel\/\",\"name\":\"Let&#039;s excel in Excel\",\"description\":\"Let&#039;s share knowledge\",\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/vmlogger.com\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\",\"name\":\"Vishwamitra Mishra\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"width\":528,\"height\":560,\"caption\":\"Vishwamitra Mishra\"},\"logo\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\"},\"description\":\"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore &amp; currently working as a Technical Lead having over 7 years of experience.\",\"sameAs\":[\"http:\/\/www.learnexcelmacro.com\",\"http:\/\/www.facebook.com\/vmlogger\",\"https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro\",\"https:\/\/www.youtube.com\/c\/VMLogger\"],\"url\":\"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Restrict to fixed text or integer length in the given range of cells - Let&#039;s excel in Excel","description":"It is very easy to implement such validation. For this no VBA code required. It can be done just by using inbuilt functionality of Excel, which is called as Data Validation. Follow below steps to Restrict to fixed text or integer length in the given range of cells","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/vmlogger.com\/excel\/2011\/11\/restrict-to-fixed-text-or-integer-length-in-the-given-range-of-cells\/","og_locale":"en_US","og_type":"article","og_title":"Restrict to fixed text or integer length in the given range of cells","og_description":"It is very easy to implement such validation. For this no VBA code required. It can be done just by using inbuilt functionality of Excel, which is called as Data Validation. Follow below steps to Restrict to fixed text or integer length in the given range of cells","og_url":"https:\/\/vmlogger.com\/excel\/2011\/11\/restrict-to-fixed-text-or-integer-length-in-the-given-range-of-cells\/","og_site_name":"Let&#039;s excel in Excel","article_publisher":"http:\/\/www.facebook.com\/vmlogger","article_author":"http:\/\/www.facebook.com\/vmlogger","article_published_time":"2011-11-10T18:18:45+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/vmlogger.com_-1.png","type":"image\/png"}],"author":"Vishwamitra Mishra","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/www.twitter.com\/learnexcelmacro","twitter_site":"@learnexcelmacro","twitter_misc":{"Written by":"Vishwamitra Mishra","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vmlogger.com\/excel\/2011\/11\/restrict-to-fixed-text-or-integer-length-in-the-given-range-of-cells\/#article","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/11\/restrict-to-fixed-text-or-integer-length-in-the-given-range-of-cells\/"},"author":{"name":"Vishwamitra Mishra","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"headline":"Restrict to fixed text or integer length in the given range of cells","datePublished":"2011-11-10T18:18:45+00:00","dateModified":"2011-11-10T18:18:45+00:00","mainEntityOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/11\/restrict-to-fixed-text-or-integer-length-in-the-given-range-of-cells\/"},"wordCount":122,"commentCount":0,"publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/11\/restrict-to-fixed-text-or-integer-length-in-the-given-range-of-cells\/#primaryimage"},"thumbnailUrl":"","articleSection":["Excel Formula","Excel Functions"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vmlogger.com\/excel\/2011\/11\/restrict-to-fixed-text-or-integer-length-in-the-given-range-of-cells\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/2011\/11\/restrict-to-fixed-text-or-integer-length-in-the-given-range-of-cells\/","url":"https:\/\/vmlogger.com\/excel\/2011\/11\/restrict-to-fixed-text-or-integer-length-in-the-given-range-of-cells\/","name":"Restrict to fixed text or integer length in the given range of cells - Let&#039;s excel in Excel","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/11\/restrict-to-fixed-text-or-integer-length-in-the-given-range-of-cells\/#primaryimage"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/11\/restrict-to-fixed-text-or-integer-length-in-the-given-range-of-cells\/#primaryimage"},"thumbnailUrl":"","datePublished":"2011-11-10T18:18:45+00:00","dateModified":"2011-11-10T18:18:45+00:00","description":"It is very easy to implement such validation. For this no VBA code required. It can be done just by using inbuilt functionality of Excel, which is called as Data Validation. Follow below steps to Restrict to fixed text or integer length in the given range of cells","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/11\/restrict-to-fixed-text-or-integer-length-in-the-given-range-of-cells\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/2011\/11\/restrict-to-fixed-text-or-integer-length-in-the-given-range-of-cells\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/2011\/11\/restrict-to-fixed-text-or-integer-length-in-the-given-range-of-cells\/#primaryimage","url":"","contentUrl":""},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/2011\/11\/restrict-to-fixed-text-or-integer-length-in-the-given-range-of-cells\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vmlogger.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel Formula","item":"https:\/\/vmlogger.com\/excel\/excel-formula\/"},{"@type":"ListItem","position":3,"name":"Restrict to fixed text or integer length in the given range of cells"}]},{"@type":"WebSite","@id":"https:\/\/vmlogger.com\/excel\/#website","url":"https:\/\/vmlogger.com\/excel\/","name":"Let&#039;s excel in Excel","description":"Let&#039;s share knowledge","publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vmlogger.com\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5","name":"Vishwamitra Mishra","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","width":528,"height":560,"caption":"Vishwamitra Mishra"},"logo":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/"},"description":"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore &amp; currently working as a Technical Lead having over 7 years of experience.","sameAs":["http:\/\/www.learnexcelmacro.com","http:\/\/www.facebook.com\/vmlogger","https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro","https:\/\/www.youtube.com\/c\/VMLogger"],"url":"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/"}]}},"_links":{"self":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12083"}],"collection":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/comments?post=12083"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12083\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media?parent=12083"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/categories?post=12083"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/tags?post=12083"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}