Note: The other languages of the website are Google-translated. Back to English

Conas spás / camóg a chur in ionad alt-enter in Excel?

Mar shampla, tá roinnt cealla le tuairisceáin ar iompar mar a thaispeántar thíos an pictiúr. Anois agus tú ag iarraidh spás nó camóg in Excel a chur in ionad na gcarachtar alt-iontrála seo, conas a d’fhéadfá déileáil leis? I ndáiríre, araon Aimsigh agus Ionadaigh gné agus is féidir le VBA cabhrú leat an fhadhb a réiteach.


Cuir spás / camóg in ionad alt-enter le gné Aimsigh agus Ionadaigh

Is féidir leat spás nó camóg a chur in ionad na gcarachtar uile-iontrála go héasca ag an Aimsigh agus Ionadaigh gné in Excel. Déan mar a leanas le do thoil:
1. Roghnaigh na cealla a chuirfidh tú in ionad na gcarachtar alt-iontráil, agus brúigh Ctrl + H eochracha chun an bosca dialóige Aimsigh agus Ionadaigh a oscailt.

2. Sa bhosca dialóige Aimsigh agus Ionadaigh, faoin Ionadaigh cluaisín, le do thoil:
(1) Sa Aimsigh Cad preas bosca Ctrl + J eochracha chun carachtar alt-iontráil a iontráil;
(2) Sa Ionadaigh le spás bosca nó camóg de réir mar is gá duit;
(3) Cliceáil ar an Ionadaigh uile cnaipe. Féach an pictiúr:

3. Cliceáil ar an OK cnaipe sa bhosca dialóige Microsoft Excel. Agus ansin dún an bosca dialóige Aimsigh agus Ionadaigh.

Anois feicfidh tú go gcuirtear do charachtar sonraithe in ionad gach carachtar alt-iontráil, mar shampla camóg. Féach an pictiúr:

Comhcheangail sraitheanna / colúin i gcill amháin agus déan iad a scaradh le spás, camóg, líne nua, srl.

Kutools le haghaidh Excel's Comhcheangail Colúin nó Sraitheanna is féidir le fóntais cabhrú le húsáideoirí Excel ilcholúin nó sraitheanna a chomhcheangal in aon cholúin / as a chéile gan sonraí a chailleadh. Ina theannta sin, is féidir le húsáideoirí Excel na teaghráin chomhcheangailte téacs seo a fhilleadh le hiompar nó le filleadh crua, camóg, spás, leathchlón, srl.


ad comhcheangail sraitheanna colún líne nua

Cuir spás / camóg in ionad alt-enter le VBA

Má tá tú eolach ar VBA, is féidir leat spás, camóg, nó aon charachtar eile a theastaíonn uait a chur in ionad VBA in Excel.

1. Brúigh Eile + F11 eochracha chun an fhuinneog Microsoft Visual Basic for Applications a oscailt.

2. Cliceáil Ionsáigh > Modúil, agus ansin greamaigh faoi bhun chód VBA isteach i bhfuinneog an mhodúil nua.

VBA: Cuir spás / camóg in Excel in ionad alt-iontráil

Sub ReplaceLineBreak()
Dim xRg As Range
On Error Resume Next
Set xRg = Application.InputBox("Select Cells:", "KuTools for Excel", Selection.Address, , , , , 8)
If xRg Is Nothing Then Exit Sub
xRg.WrapText = False
xRg.Replace Chr(10), "Your text here", xlPart, xlByColumns
End Sub

Note: Before running the VBA, please find the code xRg.Replace Chr(10), "Your text here", xlPart, xlByColumns, and replace Your text here with space, comma, or other character as you need.

3. Press F5 key or click the Run button to run this VBA.

4. In the popping out KuTools for Excel dialog box, please select the cells you will replace the alt-enter characters, and click the OK button. See screenshot:

Now you will see all alt-enter characters are replaced with you specified character, such as comma. See screenshot:


Related articles:


The Best Office Productivity Tools

Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%

  • Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
  • Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
  • Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
  • Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
  • Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
  • Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
  • Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
  • Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
  • More than 300 powerful features. Supports Office / Excel 2007-2021 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.
kte tab 201905

Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
officetab bottom
Comments (0)
No ratings yet. Be the first to rate!
There are no comments posted here yet
Leave your comments
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations

Follow Us

Copyright © 2009 - www.extendoffice.com. | All rights reserved. Powered by ExtendOffice. | Sitemap
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
Protected by Sectigo SSL