Skip to main content

Conas fad carachtair a theorannú i gcill Excel?

Is féidir le cill in Excel uasmhéid de 32,767 carachtar a shealbhú, gan ach 1,024 carachtar ar taispeáint agus gach 32,767 le feiceáil sa bharra Foirmle. Mar sin féin, b'fhéidir go mbeadh ort uaireanta ionchur úsáideora a shrianadh go líon áirithe carachtar i gcill, mar é a theorannú go 10 gcarachtar. Léireoidh an teagasc seo duit conas líon na gcarachtar i gcill Excel a theorannú go héifeachtach.

Teorainn le líon na gcarachtar i gcill

Clúdaíonn an chuid seo na céimeanna chun líon na gcarachtar is féidir a chur isteach i gcill nó i raon ceall ar leith a shrianadh.

  1. Roghnaigh an raon cille áit ar mhaith leat an teorainn fhad carachtar a fhorfheidhmiú.
  2. cliceáil Bailíochtú Sonraí sa Uirlisí Sonraí grúpa faoin Dáta Tab.
  3. sa Bailíochtú Sonraí bosca dialóige, socraigh an riail bhailíochtaithe mar seo a leanas:
    1. Ón Ceadaigh: roghchlár anuas, roghnaigh Fad an Téacs.
    2. Ón Sonraí: anuas, roghnaigh na critéir bunaithe ar do riachtanais:
      1. Roghnaigh an cothrom le rogha le haghaidh comhaireamh beacht carachtar, m.sh., 10 gcarachtar.
      2. Roghnaigh níos lú ná nó cothrom leis le haghaidh uasteorainn carachtar, m.sh., suas le 10 gcarachtar.
      3. Roghnaigh níos mó ná le haghaidh níos mó ná comhaireamh sonrach, e.g., níos mó ná 10 gcarachtar.
    3. sa Uasmhéid/Íosta/Fad: bhosca, ionchur an uimhir atá ag teastáil le haghaidh an teorainn carachtar de réir do riachtanas.
  4. cliceáil OK.

Anois, beidh úsáideoirí teoranta do théacs a ionchur laistigh de na teorainneacha carachtar socraithe sna cealla roghnaithe.

Cosc go héasca ar charachtair, uimhreacha nó litreacha speisialta a chlóscríobh i gcill / roghnú in Excel

Le Kutools le haghaidh Excel's Cosc ar Chlóscríobh gné, is féidir leat cineálacha carachtar a theorannú go héasca i gcealla Excel nó i roghnúcháin.
A. Iontráil bloc de charachtair speisialta ar nós *, !, srl .;
B. Srian a chur le clóscríobh saincharachtair, amhail uimhreacha nó litreacha áirithe;
C. Ná ceadaigh ach carachtair shonraithe a chlóscríobh, mar uimhreacha nó litreacha, de réir mar is gá duit.

Socraigh Teachtaireacht Ionchuir chun teorainn charachtair a chur ar an eolas

Anseo, míneoimid conas teachtaireachtaí ionchuir a shocrú a chuirfidh úsáideoirí ar an eolas faoi na teorainneacha carachtar sula dtosaíonn siad ag clóscríobh mar a thaispeántar an scáileán thíos:

  1. Roghnaigh na cealla ina gcuirfidh tú teachtaireacht ionchuir.
  2. cliceáil Bailíochtú Sonraí sa Uirlisí Sonraí grúpa faoin Dáta Tab.
  3. sa Bailíochtú Sonraí bosca dialóige, roghnaigh an Teachtaireacht Ionchur cluaisín, agus déan mar a leanas:
    1. seiceáil an Taispeáin teachtaireacht ionchuir nuair a roghnaítear cill rogha.
    2. Cuir isteach teideal na teachtaireachta agus ábhar na teachtaireachta.
  4. cliceáil OK.

Anois, nuair a chliceálann tú ar chill ina bhfuil an teachtaireacht ionchuir cumraithe, feicfear leid uirlisí a thaispeánfaidh teideal na teachtaireachta agus an t-ábhar a d’iontráil tú níos luaithe.

Gníomhachtaigh Foláireamh Earráide le haghaidh sáruithe ar theorainneacha carachtair

Tabharfaidh an t-alt seo treoir duit trí fholáirimh earráide a chumrú in Excel, atá deartha chun úsáideoirí a chur ar an eolas láithreach nuair nach gcomhlíonann na sonraí a iontráladh an teorainn carachtar sonraithe. Féach ar an scáileán:

  1. Roghnaigh na cealla inar mian leat foláireamh earráide a ghníomhachtú i gcás iontráil sonraí neamhbhailí.
  2. cliceáil Bailíochtú Sonraí sa Uirlisí Sonraí grúpa faoin Dáta Tab.
  3. sa Bailíochtú Sonraí bosca dialóige, roghnaigh an Foláireamh Earráide cluaisín, agus déan mar a leanas:
    1. seiceáil an Taispeáin foláireamh earráide tar éis sonraí neamhbhailí a iontráladh rogha.
    2. Roghnaigh an rabhadh rogha ón Stíl: bosca anuas.
    3. Cuir isteach teideal an foláirimh agus an teachtaireacht earráide.
  4. cliceáil OK.

As seo amach, má tá an téacs a iontráladh i gcill neamhbhailí, mar shampla níos mó ná 10 gcarachtar, beidh bosca dialóige rabhaidh le feiceáil, ag taispeáint an teideal foláirimh réamhshocraithe agus teachtaireacht.

Taispeántas: Teorainn a chur le fad carachtair sna cealla le teachtaireacht ionchuir & foláireamh rabhaidh


Kutools le haghaidh Excel: Breis is 300 uirlis láimhe ar do mhéar! Cuir tús le do thriail saor in aisce 30-lá gan aon srianta gné inniu. Íosluchtaigh Anois!

Cliceáil amháin chun cosc ​​a chur ar shonraí dúblacha a iontráil i gcolún / liosta amháin

Kutools le haghaidh Excel nuálaíoch Cosc a chur ar Dúblach Soláthraíonn fóntais d'úsáideoirí Excel an áisiúlacht chun iontrálacha dúblacha i liosta nó i gcolún a chosc gan stró. Le cliceáil amháin, cinntíonn an uirlis chumhachtach seo sláine agus cruinneas sonraí i do scarbhileoga.

Airteagal gaolmhara:

Conas iontrálacha luacha cille in Excel a theorannú?

Uirlisí Táirgiúlachta Oifige is Fearr

🤖 Kutools AI Aide: anailís sonraí a réabhlóidiú bunaithe ar: Forghníomhú Chliste   |  Gin Cód  |  Cruthaigh Foirmlí Saincheaptha  |  Anailís a dhéanamh ar Sonraí agus Cairteacha a Ghin  |  Feidhmeanna Kutools a agairt...
Gnéithe Coitianta: Faigh, Aibhsigh nó Aithnigh Dúblaigh   |  Scrios Sraitheanna Bána   |  Comhcheangail Colúin nó Cealla gan Sonraí a Chailleadh   |   Babhta gan Foirmle ...
Cuardaigh Super: Ilchritéir VLookup  |   VLookup Illuachanna  |   VLookup Trasna Ilbhileoga   |   Amharc doiléir ....
Liosta anuas Casta: Go tapa Cruthaigh Liosta Anuas   |  Liosta anuas Cleithiúnach   |  Liosta Buail Isteach Ilroghnacha ....
Bainisteoir Colún: Cuir Líon Sonrach Colún leis  |  Colúin Bog  |  Scoránaigh Stádas Infheictheachta na gColún Ceilte  |  Déan comparáid idir Raonta & Colúin ...
Gnéithe Réadmhaoin: Fócas Eangaí   |  Amharc Dearaidh   |   Barra Mór na Foirmle   |  Leabhar Oibre & Bainisteoir Bileog   |  Leabharlann Acmhainní (Uaththéacs)   |  Piocálaí Dáta   |  Comhcheangail Bileoga Oibre   |  Criptigh/Díchriptigh Cealla   |  Seol Ríomhphost trí Liosta   |  Scagaire Super   |   Scagaire Speisialta (scagaire trom/iodálach/stailc tríd...) ...
Barr 15 Uirlisí:  12 Téacs uirlisí (Cuir Téacs, Bain Carachtair,...)   |   50 + Cairt cineálacha (Cairt Gantt,...)   |   40+ Praiticiúil Foirmlí (Ríomh aois bunaithe ar lá breithe,...)   |   19 Insertion uirlisí (Cuir isteach Cód QR, Ionsáigh Pictiúr ón gCosán,...)   |   12 Tiontú uirlisí (Uimhreacha le Focail, Comhshó Airgeadra,...)   |   7 Cumaisc & Scoilt uirlisí (Sraitheanna Comhcheangail Casta, Cealla Scoilt,...)   |   ... agus eile

Supercharge Do Scileanna Excel le Kutools le haghaidh Excel, agus Éifeachtúlacht Taithí Cosúil Ná Roimhe. Kutools le haghaidh Excel Tairiscintí Níos mó ná 300 Ardghnéithe chun Táirgiúlacht a Treisiú agus Sábháil Am.  Cliceáil anseo chun an ghné is mó a theastaíonn uait a fháil ...

Tuairisc

Tugann Tab Oifige comhéadan Tabbed chuig Office, agus Déan Do Obair i bhfad Níos Éasca

  • Cumasaigh eagarthóireacht agus léamh tabbed i Word, Excel, PowerPoint, Foilsitheoir, Rochtain, Visio agus Tionscadal.
  • Oscail agus cruthaigh cáipéisí iolracha i gcluaisíní nua den fhuinneog chéanna, seachas i bhfuinneoga nua.
  • Méadaíonn do tháirgiúlacht 50%, agus laghdaíonn sé na céadta cad a tharlaíonn nuair luch duit gach lá!
Comments (54)
No ratings yet. Be the first to rate!
Olena
Olena
This comment was minimized by the moderator on the site
Thank you!
Reply
0
0
Kyaw Kyaw
Kyaw Kyaw
This comment was minimized by the moderator on the site
why date and number is allowed at text length?
Reply
0
0
Amanda Lee
Amanda Lee     Kyaw Kyaw
This comment was minimized by the moderator on the site
Hi there, numbers are also characters. So if you set the max length less than 10 characters, as long as you don't input 10 or more number characters, you will be good.

Amanda
Reply
Report
0
0
JJ
JJ
This comment was minimized by the moderator on the site
This is almost the exact solution I need but still need a bit more help. What I'm trying to achieve is to set a cell to have a max of 40 characters but not stop the user from entering all the data he needs, instead i would like anything over the 40 character limit to be populated in a second designated cell. Is this even a possibility? Thank you everyone in advance for any assistance provided.
Reply
0
0
Guest
Guest     JJ
This comment was minimized by the moderator on the site
I found this information useful to resolve a similar issue that I am facing.

https://support.microsoft.com/en-us/office/split-text-into-different-columns-with-the-convert-text-to-columns-wizard-30b14928-5550-41f5-97ca-7a3e9c363ed7
Reply
0
0
Michael
Michael
This comment was minimized by the moderator on the site
I saw Tomas question about putting an exact limit of 10 spaces and your formula =A1&REPT(" ",10-LEN(A1)) however I need to take it a step further. I want to take three separate fields that I have set their spaces to exactly 10 and concatenate them with their "spaces" intact. Also, if I don't limit what they enter and they enter MORE than 10 characters in one of the cells I want to take ONLY the first 10. So as an example, I want to give them three cells they can enter information in. I don't want to limit what they input BUT, I want to concatenate these three fields and pick up 10 characters from each one. So if the first cell has 4 characters, in my concatenate formula I want it to pick up the 4 characters PLUS 6 spaces. If the second field has 20 characters, I want to only pick up the first 10 characters and the same thing for the third cell. We are trying to get to a uniform 30 characters of description but some names are longer or shorter than others. We want this to break evenly with 10 characters per cell. Hopefully this is making sense.
Reply
0
0
Tomas
Tomas
This comment was minimized by the moderator on the site
Hi, do you know how to put exact length limit 10 and when put abc i want from excel to put 8 space?
I want to set a cell to 10 character, when input 2 character then will auto fill up with 8 space after. if the cell is blank, then return with 10 space. this is for setting a excel file for user input and save as txt or cvs file for import to other software.
Reply
0
0
kellytte
kellytte     Tomas
This comment was minimized by the moderator on the site
Hi Tomas,
You can use a formula to limit the text length: =A1 & REPT(" ",10-LEN(A1))
Reply
Report
0
0
question
question
This comment was minimized by the moderator on the site
I want to limit the quantity of a cell depending on the category of another one,

For example if I input in A1 "Ok" in B1 must be limit to 10 characters
but if A1= "NG", B1 must be limit to 12 characters.
Reply
0
0
Eliza
Eliza
This comment was minimized by the moderator on the site
[quote]Hi, do you know how to put exact length limit 10 and when put abc i want from excel to put 8 space?By Ivan[/quote] I want to set a cell to 10 character, when input 2 character then will auto fill up with 8 space after. if the cell is blank, then return with 10 space. this is for setting a excel file for user input and save as txt or cvs file for import to other software
Reply
0
0
ARNAB DEBNATH
ARNAB DEBNATH
This comment was minimized by the moderator on the site
Hi, I have a attendance sheet. from 1 to 31. I put "P" on each cell if person is present. Now I want that how many times "P" is continuing present in cell. As as example - I have put "P" from 1 to 6 , then from 8th to 9th put P, and 10th is gap. then from 11th its continue to 18th. ... now i want how many times P is continue 6 time . PPPPPP PP PPPPPPPP Manually the answer is : 2(1to6 = 1,11to18=1) If you have any formula to count this it will be a great help.
Reply
0
0
Paul
Paul     ARNAB DEBNATH
This comment was minimized by the moderator on the site
=COUNTIF(B2:B17,">""") this formula will ignore empty cells but will count cells with data in i.e. P
Reply
0
0
Shawn
Shawn
This comment was minimized by the moderator on the site
Hi. I want out put txt file and no spaces between cell values. Like 3 cells with First Name, Middle and last. Entered Shawn G Goldman as SHAWNGGOLDMAN
Reply
0
0
Shawn
Shawn
This comment was minimized by the moderator on the site
Hi I want few things in a cell. I only want numbers in cell. I want to limit to 10 characters. I want to remove decimal like 15.00 to 1500. I want to indent to right. Also to add 0's to left to make it 10 characters .like 15.00 to 0000001500
Reply
0
0
There are no comments posted here yet
Load More
Please leave your comments in English
Guest
Posting as Guest
×
Rate this post:
Reset
0   Characters
Suggested Locations