Skip to main content

Conas a láimhseáil má tá focal i gcill agus ansin téacs a chur i gcill eile?

Seo liosta d’aitheantas an táirge, agus anois ba mhaith liom a fháil amach an bhfuil sreang “KTE” sa chill, agus ansin an téacs “TRUE” a chur ina chill in aice láimhe mar atá thíos an pictiúr a thaispeántar. An bhfuil aon bhealaí gasta agat chun é a réiteach? San alt seo, táim ag caint faoi na cleasanna a bhaineann le fáil amach an bhfuil focal i gcill agus ansin téacs a chur sa chill in aice láimhe.

doc má tá focal i gcill ansin is ionann é agus 7
Má tá focal i gcill is ionann cill eile agus téacs ar leith

Má tá focal i gcill, roghnaigh nó aibhsighsmaoineamh maith3

Má tá focal i gcill is ionann cill eile agus téacs ar leith

Seo foirmle shimplí a chabhróidh leat a sheiceáil go tapa an bhfuil focal i gcill, agus ansin téacs a chur ina chéad chill eile.

Roghnaigh an chill is mian leat an téacs a chur, agus clóscríobh an fhoirmle seo = MÁ (ISNUMBER (CUARDACH ("KTE", A2)), "Fíor", "") agus ansin tarraing láimhseáil líonta uathoibríoch síos go dtí na cealla is mian leat an fhoirmle seo a chur i bhfeidhm. Féach an pictiúr:

doc má tá focal i gcill ansin is ionann é agus 8 saighead lámhaigh ar dheis doc má tá focal i gcill ansin is ionann é agus 9

 

San fhoirmle, is é A2 an chill is mian leat a sheiceáil an bhfuil focal sonrach ann, agus is é KTE an focal is mian leat a sheiceáil, Is é True an téacs is mian leat a thaispeáint i gcill eile. Féadfaidh tú na tagairtí seo a athrú de réir mar is gá duit.

Má tá focal i gcill, roghnaigh nó aibhsigh

Más mian leat a sheiceáil an bhfuil focal ar leith i gcill agus ansin é a roghnú nó aird a tharraingt air, is féidir leat an Roghnaigh Cealla Sonracha gné de Kutools le haghaidh Excel, atá in ann an post seo a láimhseáil go tapa.

Kutools le haghaidh Excel, le níos mó ná 300 feidhmeanna úsáideacha, déanann sé do phoist níos éasca. 
Téigh go dtí Íoslódáil
Triail In Aisce 30 lá

Tar éis a shuiteáil Kutools for Excel, déan mar atá thíos le do thoil :(Íoslódáil saor in aisce Kutools le haghaidh Excel Anois!)

1. Roghnaigh an raon is mian leat a sheiceáil an bhfuil focal ar leith sa chill, agus cliceáil Kutools > Roghnaigh > Roghnaigh Cealla Sonracha. Féach an pictiúr:

doc má tá focal i gcill ansin is ionann é agus 3

2. Ansin sa dialóg popping, seiceáil Cell rogha, agus roghnaigh Tá ón gcéad liosta anuas, ansin clóscríobh an focal a theastaíonn uait a sheiceáil isteach sa chéad bhosca téacs eile. Féach an pictiúr:
doc má tá focal i gcill ansin is ionann é agus 4

3. cliceáil Ok, tagann dialóg amach le cur i gcuimhne duit conas a d’fhéadfadh an focal a theastaíonn uait a fháil a bheith i gcealla, agus cliceáil OK chun an dialóg a dhúnadh. Féach an pictiúr:
doc má tá focal i gcill ansin is ionann é agus 5

4. Ansin roghnaíodh na cealla ina bhfuil an focal sonraithe, más mian leat aird a tharraingt orthu, téigh chuig Baile > Dath an Líonta dath líonta amháin a roghnú chun iad a íoc.
doc má tá focal i gcill ansin is ionann é agus 6

Leid. Más mian leat triail saor in aisce a fháil ar an Roghnaigh Cealla Sonracha feidhm, téigh chuig Kutools le haghaidh Excel le híoslódáil saor in aisce ar dtús, agus ansin téigh chun an oibríocht a chur i bhfeidhm de réir na gcéimeanna thuas.

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 (21)
No ratings yet. Be the first to rate!
Flavia
Flavia
This comment was minimized by the moderator on the site
Buenas noches,

Tengo una columna con varias categorías de tareas (administrativo, profesor, etc) y quiero armar la columna siguiente indicando si es x tarea que sea nivel alto, si es otra Medio y así. Intenté con la fórmula SI y SI. CONJUNTO pero no parece funcionar cuando no hay valores numéricos. Vi ejemplos pero con si C2 es mayor que entonces tal palabra...
Reply
0
0
luis alberto
luis alberto
This comment was minimized by the moderator on the site
Buen día, disculpa, queria ver si me puedes ayudar con una formula.

En una celda tengo una oracion, y quiero que la celda de un lado me escriba cierta letra o palabra cuando en la primera celda tenga alguna palabra.

Ejemplo
en la celda A1 tengo una oracion: papa manzana pasta, lechuga.
en la celda A2 tengo: papa manzana, zanahoria, lechuga.

Quiero que en la celda B1 me aparezca la palabra "ensalada" solo porque en la A1 tiene "lechuga"
y en la celda B2 me aparezca la palabra: "arbol" porque tiene la palabra "manzana"

Nota quiero que de prioridad a la lechuga antes que a la manzana
Sino se puede dar prioridad entonces digamos que quitamos la palabra "manzana" de la primera oracion


No se si me di a entender, no se me ocurrio como dar el ejemplo
Reply
Report
0
0
Sunny
Sunny     luis alberto
This comment was minimized by the moderator on the site
Hi, luis, here is a formula may help you.
Take an example for explaining the formula, if cell contains "KTE" then returns "Y", if cell contains "KTW" then returns "T", if cell contains both of "KTE' and "KTW" then returns "Y".
=IF(AND(ISNUMBER(SEARCH("KTE",A3)), ISNUMBER(SEARCH("KTW",A3)) ),"Y", IF(ISNUMBER(SEARCH("KTE",A3)), "Y", IF(ISNUMBER(SEARCH("KTW",A3)), "T", "")))
change the reference and the values as you need.
https://www.extendoffice.com/images/stories/comments/sun-comment/doc-return-value-based-on-word.png
Tip: If you in spanish version, maybe need to change the formula to spanish formula.
Reply
Report
0
0
Andy
Andy
This comment was minimized by the moderator on the site
How do you keep this going, if I have 5 other unique labels that need to spit out 5 other unique corresponding phrases?
Reply
0
0
Sunny
Sunny     Andy
This comment was minimized by the moderator on the site
Hi, Andy, yes, you need to use 5 different formulas to acheive your purpose.
Reply
Report
0
0
andi
andi
This comment was minimized by the moderator on the site
kolom satu
adam
andi
budi
dst

kolom dua
andi jaya
budiarto
adam malik
dst


kolom 3 (hasil pakai rumus)


pertanyaan:
bagaimana rumus di kolom 3, jika kita ingin memunculkan nama kolom 2 dikolom 3 yg mengandung teks di kolom satu.

saya minta petunjuk dari para pakar excel.

Terima kasih
Andi
Reply
0
0
Sunny
Sunny     andi
This comment was minimized by the moderator on the site
Hi, Andi, I realy like to help you, but I cannot read your language, could you login and upload a screenshot to show the result you want? Then I will try to find method to solve it.
Reply
Report
0
0
andi
andi
This comment was minimized by the moderator on the site
kolom satu kolom dua kolom 3 (hasil rumus)
adam andi jaya
andi budiarto
budi adam malik
dst dst

bagaimana rumus di kolom 3, jika kita ingin memunculkan nama kolom 2 dikolom 3 yg mengandung teks di kolom satu.

saya minta petunjuk dari para pakar excel.

Terima kasih
Andi
Reply
0
0
Alex
Alex
This comment was minimized by the moderator on the site
If column has text, alpha-numeric & numeric values, using the convert tool does not apply the text values to numeric. Makes sense. Though, how could you configure a IF Vlookup to compensate if a cell has text?
Reply
0
0
Sunny
Sunny     Alex
This comment was minimized by the moderator on the site
Sorry, which convert tool you mean? The formula can work correctly whatever the column contains alpha, alpha-numeric or numeric string.
Reply
Report
0
0
Sean
Sean
This comment was minimized by the moderator on the site
Hello,

Question. If I need this formula to apply to two different returns. For example, if a cell contains the word "Senior", another cell would return "32" and if the cell contains "Associate" then the other cell would return 16.
Reply
0
0
samgunderson@gmail.com
    Sean
This comment was minimized by the moderator on the site
Here's the formula. Assume there's a list of titles starting in cell A2:

Senior Engineer
Associate Engineer
Senior Engineer
Senior Engineer
Vice President
Associate Engineer
Associate Engineer
Senior Vice Presdent

In cell B2 (or whatever cell you wish to populate with the results), write:

=IF(ISNUMBER(FIND("Senior",A2)),"32",IF(ISNUMBER(FIND("Associate",A2)),"16"))

You could check for additional values by adding additional nested IF statements.
Reply
Report
0
0
Sunny
Sunny     Sean
This comment was minimized by the moderator on the site
Sorry I cannot figore out the correct formula to solve your problem, you can go to our forum https://www.extendoffice.com/forum.html to place your question, maybe someone can help you.
Reply
Report
0
0
Bryanna
Bryanna
This comment was minimized by the moderator on the site
Thanks for this. Can this code be edited so that instead of placing specific text beside the source text, it can be formatted to place the text in a different cell?
Reply
0
0
Helen
Helen     Bryanna
This comment was minimized by the moderator on the site
i know what u mean. i need this function to.
Reply
0
0
Sunny
Sunny     Helen
This comment was minimized by the moderator on the site
Do you mean to extract the text in different cell while the cell contains the specifict text as below screenshot shown?
View Attachments (1 / 5)
Reply
Report
0
0
Sunny
Sunny     Bryanna
This comment was minimized by the moderator on the site
Sorry, I do not realy understand your question. Could you give me more detail description?
Reply
Report
0
0
Kas
Kas
This comment was minimized by the moderator on the site
How would you write the formula is you have text-text-text and you want to pull the final text? AB-GUFJ-CD if you want to pull the CD?
Reply
0
0
Sunny
Sunny     Kas
This comment was minimized by the moderator on the site
Hello, this formula may help you =TRIM(RIGHT(SUBSTITUTE(A12,"-",REPT(" ",255)),255)), A12 is the text string you use, change it as you need. If it works, please let me know. Thanks.
Reply
Report
0
0
Wise Guy
Wise Guy
This comment was minimized by the moderator on the site
LOL ...did you mean True?
Reply
0
0
Sunny
Sunny     Wise Guy
This comment was minimized by the moderator on the site
Embarrrassed...yes, I mean true~~, I have rewrote it, thank u for ur remind.
Reply
Report
0
0
There are no comments posted here yet
Please leave your comments in English
Guest
Posting as Guest
×
Rate this post:
Reset
0   Characters
Suggested Locations