Skip to main content

Conas fad carachtair i gcill in Excel a theorannú?

Uaireanta, b’fhéidir gur mhaith leat teorainn a chur le cé mhéad carachtar is féidir le húsáideoir a ionchur i gcill. Mar shampla, ba mhaith leat teorainn a chur le 10 gcarachtar a ionchur i gcill. Taispeánfaidh an rang teagaisc seo duit na sonraí chun carachtair i gcill in Excel a theorannú.


Teorainn a chur le fad carachtair i gcill

1. Roghnaigh an raon a chuirfidh tú teorainn le hiontrálacha dáta le fad carachtar a shonrú.

2. Cliceáil ar an Bailíochtú sonraí sa Uirlisí Sonraí grúpa faoi Dáta Tab.

3. Sa bhosca dialóige Bailíochtaithe Sonraí, roghnaigh an Fad an Téacs mír ón Ceadaigh: bosca anuas. Féach an griangraf seo a leanas:

4. Sa an Sonraí: bosca anuas, gheobhaidh tú a lán roghanna agus roghnóidh tú ceann, féach an griangraf seo a leanas:

(1) Más mian leat nach bhfuil daoine eile in ann ach líon cruinn carachtair a iontráil, a deir 10 gcarachtar, roghnaigh an cothrom le mír.
(2) Más mian leat nach mó ná 10 líon na gcarachtar ionchuir, roghnaigh an níos lú ná mír.
(3) Más mian leat nach lú ná 10 líon na gcarachtar ionchuir, roghnaigh an níos mó ná mír.

4. Uimhir bheacht iontrála ar mhaith leat a theorannú Uasmhéid/Íosta/Fad bosca de réir do riachtanas.

5. Cliceáil OK.

Anois ní féidir le húsáideoirí téacs a iontráil ach le líon teoranta carachtar i raonta roghnaithe.

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

Le Kutools for Excel's Cosc ar Chlóscríobh gné, is féidir leat cineálacha carachtar a theorannú go héasca i gcill nó i roghnú in Excel.


A. Cosc a chur ar chlóscríobh carachtair speisialta, mar shampla *, !, srl .;
B. Cosc a chur ar charachtair áirithe a chlóscríobh, mar shampla uimhreacha, nó litreacha áirithe;
C. Ná lig ach carachtair áirithe a chlóscríobh, mar shampla uimhreacha, litreacha, srl. Mar a theastaíonn uait.
cosc a chur ar chlóscríobh chars

Socraigh Teachtaireacht Ionchuir le haghaidh teorannú fad téacs

Ligeann an Bailíochtú Sonraí dúinn teachtaireacht ionchuir a shocrú le haghaidh teorannú fad téacs seachas cill roghnaithe mar atá thíos an pictiúr a thaispeántar:

1. Sa bhosca dialóige Bailíochtaithe Sonraí, aistrigh go dtí an Teachtaireacht Ionchur Tab.

2. seiceáil an Taispeáin teachtaireacht ionchuir nuair a roghnaítear cill mar rogha.

3. Iontráil teideal na teachtaireachta agus ábhar na teachtaireachta.

4. Cliceáil OK.

Anois téigh ar ais go dtí an bhileog oibre, agus cliceáil cill amháin i raon roghnaithe le teorannú fad téacs, taispeánann sé barr le teideal agus ábhar na teachtaireachta. Féach an griangraf seo a leanas:


Socraigh Foláireamh Earráide le haghaidh teorannú fad téacs

Bealach eile chun a chur in iúl don úsáideoir go bhfuil an cill teoranta de réir fhad an téacs is ea earráid a athrú. Taispeánfar an foláireamh earráide tar éis duit sonraí neamhbhailí a iontráil. Féach an pictiúr:

1. Sa bhosca dialóige Bailíochtaithe Sonraí, aistrigh go dtí an Foláireamh Earráide dialóg.

2. seiceáil an Taispeáin foláireamh earráide tar éis sonraí neamhbhailí a iontráladh rogha.

3. Roghnaigh an rabhadh mír ón Stíl: bosca anuas.

4. Ionchur an teideal foláirimh agus an teachtaireacht foláirimh.

5. Cliceáil OK.

Anois má tá an téacs a chuir tú isteach i gcill neamhbhailí, mar shampla tá níos mó ná 10 gcarachtar ann, nochtfaidh bosca dialóige rabhaidh teideal agus teachtaireacht réamhshocraithe réamhshocraithe. Féach an griangraf seo a leanas:


Taispeántas: teorainn a chur le fad na gcarachtar i gcealla le teachtaireacht ionchuir & rabhadh foláirimh


Kutools for 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

Comparáid a dhéanamh le bailíochtú sonraí a shocrú ceann ar cheann, Kutools for Excel's Cosc a chur ar Dúblach Tacaíonn fóntais le húsáideoirí Excel cosc ​​a chur ar iontrálacha dúblacha i liosta nó i gcolún gan ach cliceáil amháin.


cosc a chur ar dhúbailtí a chlóscríobh


Airteagal gaolmhara:

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

Uirlisí Táirgiúlachta Oifige is Fearr

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 for Excel, agus Éifeachtúlacht Taithí Cosúil Riamh Roimhe. Kutools for Excel Tairiscintí os cionn 300 Ardghné chun Táirgiúlacht a Mhéadú agus Am a Shábháil.  Cliceáil anseo chun an ghné is mó a theastaíonn uait a fháil ...

cluaisín kte 201905


Office Tab Tugann sé comhéadan Tabbed chuig Oifig, agus Déan do chuid Oibre 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 (53)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
why date and number is allowed at text length?
This comment was minimized by the moderator on the site
Hi there, if you want me to explain, 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
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.
This comment was minimized by the moderator on the site
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.
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.
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))
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.
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
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.
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
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
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
This comment was minimized by the moderator on the site
Sir, How to set Cells with following Condition If one letter will enter go to first cell and 2nd letter automatically goto next cell. How we will set this. Help me.
There are no comments posted here yet
Load More
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations