Haddii aad rabto inaad ku darto xadka xarfaha Excel iyo Google Sheets^{(add a character limit in Excel and Google Sheets)} , markaa maqaalkani wuxuu ku caawin doonaa. Waxaad sidoo kale muujin kartaa qalad ama fariinta digniinta sidoo kale. Haddii aad isticmaalayso Word desktop app ama Excel Online , waxaad ku samayn kartaa isla casharkan.

Aynu ka soo qaadno inaad rabto inaad xaashida xaashida la wadaagto xubnaha kooxdaada, laakiin ma rabto inaad u ogolaato inay galaan qiime ka badan tiro gaar ah. Si kale haddii loo dhigo, waxaad dooneysaa inaad dejiso xadka xarfaha si aad u xaddiddo isticmaaleyaasha inay galaan qiimaha soo mara filtarrada hore loo diyaariyey. Iyadoo ay fududahay in lagu muujiyo qalad ama fariinta digniinta ee Excel^{(show an error or alert message in Excel)} , tilmaan-bixiyahan waxaanu dejin doonaa xadka dhammaan apps-yada caadiga ah ee aad isticmaasho si aad u saxdo xaashida.

Sida loo dejiyo xadka Character gudaha ^(Character)Excel

Si aad ugu darto xadka xarfaha Excel , raac talaabooyinkan-

1. Fur xaashida faafinta oo dooro unug.
2. Tag tab xogta^(Data)
3. Ka dooro Xaqiijinta ^{(Data Validation)}Xogta^{(Data Validation)} liiska hoos-u-dhaca ee Xaqiijinta Xogta.
4. Kordhi dhererka qoraalka^{(Text length)} ee Oggolow^(Allow) liiska hoos u-dhaca.
5. Ka dooro shuruudaha liiska xogta^(Data) .
6. Geli dhererka qoraalka sanduuqyada ugu ^(Maximum)yar^(Minimum) iyo kan ugu badan.
7. Guji badhanka OK

Si aad wax badan u ogaato, sii wad wax akhriska.

Marka hore, waa inaad furto xaashida xaashida ee Excel oo aad doorataa unug. Kadib, u gudub  xogta ^(Data ) tab oo balaadhi  liiska hoos-u-dhaca ee Xaqiijinta Xogta  . ^{(Data Validation )}Halkan waxa aad ka heli doontaa ikhtiyaar la yidhaahdo  Xaqiijinta Xogta^{(Data Validation)} . Ku dhufo

Marka daaqada la furo, hubi inaad ku jirto  Settings  tab. Hadday sidaas tahay, balaadhi  Oggolow ^(Allow ) liiska hoos-u-dhaca, oo dooro  dhererka qoraalka^{(Text length)} . Taas ka dib, ka dooro shuruudaha xaddidaadda  liiska xogta ^(Data ) .

Marka xigta, waa inaad gelisaa xadka xarfaha sida ku cad xulashada xogtaada . ^(Data)Marka la sameeyo, dhagsii  badhanka OK  .

Hadda wixii ka dambeeya, mar kasta oo aad ku guul dareysato inaad u hoggaansanto xadka unugga gaarka ah, waxay ku tusi doontaa farriin qalad ah.

Sida loogu daro xadka xarfaha Excel Online

Si aad ugu darto xadka xarfaha Excel Online , raac talaabooyinkan-

1. Ku fur xaashida xisaabaadka gudaha Excel Online.
2. U beddel xogta^(Data) tab
3. Guji ikhtiyaarka Xaqiijinta Xogta .^{(Data Validation)}
4. Ka dooro Length Text^{(Text Length)} liiska Oggolow^(Allow) .
5. Ka dooro xadka xarfaha liiska xogta^(Data) .
6. Geli xadka sanduuqyada ugu ^(Maximum)yar^(Minimum) iyo kan ugu badan.
7. Guji badhanka OK

Si aad u bilowdo, ka fur xaashida xaashida ee Excel Online oo u beddel  xogta ^(Data ) tab. Halkan waxaad ku arki doontaa ikhtiyaarka la yiraahdo  Xaqiijinta Xogta^{(Data Validation)} . Ku dhufo

Ka dib marka aad furto daaqada, balaadhi  Allow  liiska hoos-hoosaadka, oo dooro  Length Text^{(Text Length)} . Taas ka dib, ka dooro shuruudaha  liiska hoos-u-dhaca Xogta  . ^(Data )Marka xigta, waa inaad gelisaa xadka xarfaha sanduuqyada ugu sarreeya^(Maximum) iyo kan ugu yar .^(Minimum)

Ugu dambeyntii, dhagsii  badhanka OK  si aad u badbaadiso isbeddelka. Macluumaadkaaga, waxaad tusi kartaa Fariinta Galinta^{(Input Message)} iyo Digniinta Cilada^{(Error Alert)} . Waxay soo muuqdaan mar kasta oo qof isku dayo inuu galo qiime ama galo qiime khaldan unugga la doortay. Taas awgeed, u beddel  fariinta ^{(Input Message )} wax gelinta ama  tab digniinta qaladka ^{(Error Alert )} , oo geli fariinta aad rabto inaad muujiso.

Sida loo xaddido xarfaha Google - ka^(Google)

Si aad ugu darto xadka Google Sheets , raac tillaabooyinkan-

1. Ku fur xaashida xaashida Google^{(Google Sheets)} -ka .
2. Dooro unug.
3. Guji Xogta^(Data) ku jirta bar menu-ka.
4. Ka dooro ansaxinta xogta^{(Data validation)} liiska
5. Dooro kala duwanaanta unugga^{(Cell range)} .
6. Balaadhi liiska hoos-u-dhaca shuruudaha oo dooro ^(Criteria)qaacidada gaarka ah waa^{(Custom formula is)} ikhtiyaar.
7. Enter =regexmatch (A3&””,”^(.){1,5}$”) sanduuqa soo socda.
8. Dooro ikhtiyaarka digniinta Muuji^{(Show warning)}
9. Guji badhanka Save .

Aynu eegno nooca faahfaahsan ee tillaabooyinkan.

Marka hore, fur xaashida xaashida Google^{(Google Sheets)} oo dooro unug meesha aad rabto inaad ku darto shaandhada. Taas ka dib, dhagsii  ikhtiyaarka Xogta ^(Data ) ee ku yaal bar menu-ka sare oo dooro  xulashada ansaxinta xogta ^{(Data validation )} liiska.

Marka la furo, dooro  kala duwanaanta unugga^{(Cell range)} . Haddii ay tahay hal unug, ma jiraan wax qasab ah in la beddelo. Kadibna, balaadhi  liiska hoos-u-dhaca  Shuruudaha  , oo dooro ^(Criteria )qaacidada gaarka ah waa ^{(Custom formula is )} ikhtiyaarka.

Marka xigta, waa inaad gelisaa qaacidooyinka soo socda sanduuqa u dhigma-

=regexmatch(A1&"","^(.){1,6}$")

Kahor intaadan talaabada xigta aadin, waxaa loo baahan yahay inaad beddesho laba shay oo waafaqsan shuruudahaaga. Marka hore^(First) ,  A1  waxay u taagan tahay lambarka gacanta. Labaad^(Second) ,  1,6  ayaa qeexaya xadka dabeecadda. Haddii aad dejiso wax la mid ah sida halkan lagu sheegay, waxay samayn doontaa kuwan soo socda- isticmaalayaashu kuma dari karaan wax ka badan 6 unugga A1.

Sida Excel iyo Excel Online , waxaad muujin kartaa digniin ama qoraal macluumaad. Taas awgeed, sax  sanduuqa qoraalka caawinta ansixinta Muuji ^{(Show validation help text )} , oo geli qoraal. Marka laga reebo taas, waxaad si toos ah u diidi kartaa qiimaha. Taas awgeed, dooro  Dii gelinta ^{(Reject input )} halka aad ka dooran lahayd  muujinta digniinta^{(Show warning)}  .

Ugu dambeyntii, dhagsii  badhanka Save  si aad u badbaadiso isbeddelka.

Waa intaas! Rajo in ay ku caawin

How to set a Character limit in an Excel and Google Sheets

If you want to add a character limit in Excel and Google Sheets, then this article will help you. You can also show an error or alert message as well. Whether you are using the Word desktop app or Excel Online, you can do the same with this tutorial.

Let’s assume that you want to share a spreadsheet with your team members, but you do not wish to allow them to enter a value more than a specific number. In other words, you want to set a character limit so that you can limit users from entering a value that goes through the preset filter. While it is easy to show an error or alert message in Excel, in this guide we will set the character limit in all the common apps that you use to edit a spreadsheet.

How to set a Character limit in Excel

To add a character limit in Excel, follow these steps-

1. Open a spreadsheet and select a cell.
2. Go to the Data tab.
3. Select Data Validation from the Data Validation drop-down list.
4. Expand Text length from Allow drop-down list.
5. Select the criteria from the Data list.
6. Enter a text length in the Minimum and Maximum boxes.
7. Click on the OK button.

To know more, keep reading.

At first, you will have to open a spreadsheet in Excel and select a cell. Then, go to the Data tab and expand the Data Validation drop-down list. Here you will find an option called Data Validation. Click on it.

Once the window is opened, make sure that you are in the Settings tab. If so, expand the Allow drop-down list, and select Text length. Following that, select limitation criteria from the Data list.

Next, you will have to enter a character limit as per your Data selection. Once done, click on the OK button.

From now onward, whenever you fail to comply with the limit in the specific cell, it will show you an error message.

How to add a character limit in Excel Online

To add a character limit in Excel Online, follow these steps-

1. Open a spreadsheet in Excel Online.
2. Switch to the Data tab.
3. Click on the Data Validation option.
4. Select Text Length from the Allow list.
5. Select a character limit from the Data list.
6. Enter the limit in the Minimum and Maximum boxes.
7. Click on the OK button.

To get started, open a spreadsheet in Excel Online and switch to the Data tab. Here you will see an option called Data Validation. Click on it.

After opening the window, expand the Allow drop-down list, and select Text Length. Following that, select a requirement from the Data drop-down list. Next, you will have to enter the character limit in the Maximum and Minimum boxes.

At last, click on the OK button to save the change. For your information, you can show an Input Message and Error Alert. They appear whenever someone tries to enter a value or enter a wrong value in the selected cell. For that, switch to the Input Message or Error Alert tab, and enter the desired message that you want to show.

How to limit Characters in Google Sheets

To add a character limit in Google Sheets, follow these steps-

1. Open a spreadsheet in Google Sheets.
2. Select a cell.
3. Click on Data in the menu bar.
4. Select Data validation from the list.
5. Select the Cell range.
6. Expand Criteria drop-down list and select Custom formula is option.
7. Enter =regexmatch(A3&””,”^(.){1,5}$”) in the following box.
8. Select the Show warning option.
9. Click on the Save button.

Let’s check out the detailed version of these steps.

At first, open a spreadsheet in Google Sheets and select a cell where you want to add the filter. Following that, click on the Data option in the top menu bar and choose the Data validation option from the list.

Once it is opened, select a Cell range. If it is one cell, nothing is mandatory to change. Then, expand the Criteria drop-down list, and choose the Custom formula is option.

Next, you will have to enter the following formula in the corresponding box-

=regexmatch(A1&"","^(.){1,6}$")

Before going to the next step, it is required to change two things according to your requirement. First, A1 represents the cell number. Second, 1,6 defines the character limit. If you set the same thing as mentioned here, it will do the following- users cannot add any value more than 6 in the A1 cell.

Like Excel and Excel Online, you can show a warning or information text. For that, check the Show validation help text box, and enter a text. Apart from that, you can reject the value directly. For that, select Reject input instead of the Show warning option.

At last, click the Save button to save the change.

That’s all! Hope it helps.

Related posts

• Sida loo muujiyo Taariikhda iyo Waqtiga Hadda ee Excel iyo Google Sheets

• Sida loo sameeyo liiska hoos u dhaca ee Excel iyo Google Sheets

• Sida loogu xidho Google Sheets iyo Excel

• Sida loo sameeyo garaaf xariiq qaloocan gudaha Excel iyo Google Sheets

• Xaashiyaha Google ee ugu Fiican iyo Hababka Jadwalka Kalandarka ee Excel Online

• Sida loo isticmaalo Muddada Dhaqaale Function gudaha Excel

• Sida loo isticmaalo Rept Function gudaha Excel

• U beddelo Word, PowerPoint, Excel Documents PDF adoo isticmaalaya Google Docs

• Sida loo tiriyo lambarka Haa ama Maya ee Excel

• Sida loo xidho unugyada qaacidada Excel si loo ilaaliyo

• Sida loo dayactiro buug-shaqeedka Excel ee xumaaday

• Microsoft Excel waxay isku dayaysaa inay soo ceshato macluumaadkaaga

• Sida loo abuuro oo loo isticmaalo Koontaroolada Foomka gudaha Excel

• Sida Zero loogu daro lambarka hortiisa ee Excel iyo Google Sheets

• Sida loo qariyo xaashiyaha, unugyada, tiirarka, iyo qaaciidooyinka gudaha Excel

• Ku tiriso qiimayaasha kala go'ay ee hal unug ee Excel iyo Google Sheets

• Sida loo isticmaalo shaqada HLOOKUP ee Microsoft Excel

• Sida otomaatig loogu sameeyo hawlaha xaashida Google ee Macros

• Sida loo beddelo Kiiska qoraalka ee Word iyo Google Sheets

• Sida loo geliyo WordArt xaashida Google-ka iyadoo la isticmaalayo Google Drawings