Skip to main content

Conas comharthaí athfhriotail timpeall téacs a bhaint as cill in Excel?

Chun comharthaí athfhriotail timpeall téacsanna a bhaint de chealla roghnaithe, soláthraíonn an t-alt seo dhá mhodh duit chun é a bhaint amach.

Bain comharthaí athfhriotail timpeall an téacs ón gcill le feidhm Aimsigh agus Ionadaigh
Bain marcanna athfhriotail timpeall an téacs ón gcill le Kutools le haghaidh Excel

Bain comharthaí athfhriotail timpeall an téacs ón gcill le feidhm Aimsigh agus Ionadaigh

Má cheaptar go bhfuil liosta dáta agat le comharthaí athfhriotail timpeall mar a thaispeántar thíos an pictiúr. Is féidir leat na comharthaí athfhriotail seo a bhaint ó chealla leis an bhfeidhm Excel in Find and Replace. Déan mar a leanas le do thoil.

1. Roghnaigh an raon le comharthaí athfhriotail a theastaíonn uait a bhaint. Cliceáil Faigh & Roghnaigh > Aimsigh faoi Baile tab chun an Aimsigh agus Ionadaigh dialóg.

nótaí: Is féidir leat an Ctrl + F eochracha ag an am céanna chun é seo a oscailt Aimsigh agus Ionadaigh dialóg.

2. Sa Aimsigh agus Ionadaigh bosca dialóige, cliceáil an Ionadaigh cluaisín, cuir isteach marc athfhriotail " isteach sa Aimsigh cad bosca, agus coinnigh an Ionadaigh le bosca bán, ansin cliceáil ar an Ionadaigh uile cnaipe. Féach an pictiúr:

3. Cliceáil ar an OK cnaipe sa bhosca dialóige aníos seo a leanas.

Ansin feiceann tú go mbaintear gach marc athfhriotail timpeall ar théacsanna i raon roghnaithe láithreach.

Bain marcanna athfhriotail timpeall an téacs ón gcill le Kutools le haghaidh Excel

Leis an Bain Carachtair fóntais de Kutools le haghaidh Excel, is féidir leat gach marc athfhriotail i raon roghnaithe in Excel a bhaint go héasca.

Roimh iarratas a dhéanamh Kutools le haghaidh Excel, Le do thoil é a íoslódáil agus a shuiteáil ar dtús.

1. Roghnaigh an raon le comharthaí athfhriotail a theastaíonn uait a bhaint, agus ansin cliceáil Kutools > Téacs > Bain Carachtair. Féach an pictiúr:

2. Sa Bain Carachtair bosca dialóige, seiceáil an An Chustaim bosca, cuir marc athfhriotail isteach sa bhosca seo a leanas, agus ansin cliceáil ar an OK cnaipe. Féach an pictiúr:

Ansin baintear na comharthaí athfhriotail den raon roghnaithe láithreach.

nótaí: Chun luachan aonair a bhaint de chealla, ní gá ach luachan amháin a iontráil ' isteach sa An Chustaim bosca.

  Más mian leat triail saor in aisce (30 lá) a bheith agat ar an bhfóntas seo, cliceáil le do thoil chun é a íoslódáil, agus ansin téigh chun an oibríocht a chur i bhfeidhm de réir na gcéimeanna thuas.

Bain marcanna athfhriotail timpeall an téacs ón gcill le Kutools le haghaidh Excel

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 (9)
Rated 4.75 out of 5 · 2 ratings
TATI GIRALDO
TATI GIRALDO
This comment was minimized by the moderator on the site
ME HAS SALVADO LA VIDA, MUY UTIL Y SIN TANTOS RODEOS.

DIOS LE PAGUE
Reply
0
0
Rated 5 out of 5
Key
Key
This comment was minimized by the moderator on the site
Muchas graciaaaaas, me salvaste :) Bendiciones :3
Reply
0
0
Rated 4.5 out of 5
Lee
Lee
This comment was minimized by the moderator on the site
I couldn't get this to work today, replace doesn't like characters such as - or " so I came up with this formula. =MID(cell#,2,LEN(cell#)-2)
This assumes the quotation marks are the first and last character in the cellEnter this formula in the cell next to the text string cell then copy and paste as text into another column to get the resultcell# is the text string cell
Reply
0
0
benben
benben
This comment was minimized by the moderator on the site
Hi All,

There is unseen quotation marks in my cells that I want to remove. The text is BS_20C37_Wedgewood but whenever I copy and paste it to other platform it shows like this "BS_20C37_Wedgewood "

It adds " in front of the text and (space)" at the end.

Please do help me. Thanks!
Reply
0
0
Jordan
Jordan     benben
This comment was minimized by the moderator on the site
You can enter =CLEAN(Cell#) in a blank cell then copy the result and paste special value only into the original cell
Reply
0
0
crystal
crystal     benben
This comment was minimized by the moderator on the site
Dear benben,

Normally the quotation marks don't hide automaically in cells. Would you send me your workbook via ?
Thank you for your comment.
Reply
Report
0
0
Rits
Rits
This comment was minimized by the moderator on the site
Hi All,

I have single inverted comma ( ' ) in my Some cells of excel and for some cell it doesn't. The comma is start of the string value, could you please help me out to remove that single inverted comma ?

Example of column
CUSIP
135087XG4
'13509PFL2
'13509PDV2
'135087G40
'135087B45
Reply
0
0
crystal
crystal     Rits
This comment was minimized by the moderator on the site
Dear Rits,

Thank your for your comment!
We have an article "How to remove inverted commas from cells in Excel?" which include two methods of removing single inverted comma from specified range cells in details. Please follow the below link for more information. Hope the methods can help you solving the problem.

https://www.extendoffice.com/documents/excel/3394-excel-remove-inverted-commas.html

If you have any further questions please don't hesitate to contact me.

Best Regards, Crystal
Reply
Report
0
0
joy ignatius
joy ignatius
This comment was minimized by the moderator on the site
thank you so much..each and every concept clearly with screenshot..thank you so much..really its very helpful for me..
Reply
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