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

如何在Excel中用空格/逗号替换alt-enter?

例如,一些带有回车符的单元格如下图所示。 现在,您要在Excel中用空格或逗号替换这些alt输入字符,如何处理? 实际上,两者 查找和替换 功能和VBA可以帮助您解决问题。


通过查找和替换功能将alt输入替换为空格/逗号

您可以轻松地用空格或逗号将所有输入字符替换为 查找和替换 Excel中的功能。 请执行以下操作:
1。 选择要替换alt输入字符的单元格,然后按 按Ctrl + H 键打开“查找和替换”对话框。

2。 在“查找和替换”对话框的“ 更换 标签,请:
(1)在 寻找什么 压盒机 按Ctrl + J 输入alt输入字符的键;
(2)在 更换 所需的框型空格或逗号;
(3)点击 “全部替换” 按钮。 看截图:

3。 点击 OK 在弹出的Microsoft Excel对话框中单击按钮。 然后关闭“查找和替换”对话框。

现在,您将看到所有alt输入字符都替换为您指定的字符,例如逗号。 看截图:

将行/列合并为一个单元格,并用空格,逗号,换行符等分隔。

Kutools for Excel的 合并列或行 实用程序可以帮助Excel用户轻松地将多列或多行合并为一列/行,而不会丢失数据。 此外,Excel用户可以将这些组合的文本字符串用回车或硬回车,逗号,空格,分号等进行包装。


广告合并行列换行符

用VBA将alt输入替换为空格/逗号

如果您熟悉VBA,则还可以在Excel中使用VBA将alt输入字符替换为空格,逗号或任何其他字符。

1。 按 其他 + F11 键以打开“ Microsoft Visual Basic应用程序”窗口。

2。 点击 插页 > 模块,然后将以下VBA代码粘贴到新的模块窗口中。

VBA:用Excel中的空格/逗号替换alt输入

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