如何在Excel中用空格/逗号替换alt-enter？
例如，一些带有回车符的单元格如下图所示。 现在，您要在Excel中用空格或逗号替换这些alt输入字符，如何处理？ 实际上，两者 查找和替换 功能和VBA可以帮助您解决问题。
通过查找和替换功能将alt输入替换为空格/逗号
用VBA将alt输入替换为空格/逗号
通过查找和替换功能将alt输入替换为空格/逗号
您可以轻松地用空格或逗号将所有输入字符替换为 查找和替换
Excel中的功能。 请执行以下操作：
1。 选择要替换alt输入字符的单元格，然后按
按Ctrl +
H 键打开“查找和替换”对话框。
2。 在“查找和替换”对话框的“ 更换
标签，请：
（1）在
寻找什么 压盒机
按Ctrl +
J
输入alt输入字符的键;
（2）在
更换
所需的框型空格或逗号；
（3）点击
“全部替换”
按钮。 看截图：
3。 点击 OK
在弹出的Microsoft Excel对话框中单击按钮。 然后关闭“查找和替换”对话框。
现在，您将看到所有alt输入字符都替换为您指定的字符，例如逗号。 看截图：
将行/列合并为一个单元格，并用空格，逗号，换行符等分隔。
Kutools for Excel“ 合并列或行 实用程序可以帮助Excel用户轻松地将多列或多行合并为一列/行，而不会丢失数据。 此外，Excel用户可以将这些组合的文本字符串用回车或硬回车，逗号，空格，分号等进行包装。
全功能免费试用 30-天！
如果您熟悉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:
How to replace blank space with nothing/underscore/dash/comma in Excel?
Best Office Productivity Tools
Transform Hours into Minutes with Kutools for Excel!
Ready to supercharge your Excel tasks? Harness the power of Kutools for Excel - your ultimate time-saving tool. Streamline intricate tasks and glide through your data like a pro. Experience Excel at lightning speed!
Why You Need Kutools for Excel
🛠️ Over 300 Powerful Features: Kutools is packed with more than 300 advanced features, simplifying your work in over 1500 scenarios.
📈 Superior Data Processing: Merge cells, remove duplicates, and perform advanced data conversions – all without breaking a sweat!
⏱️ Efficient Batch Operations: Why put in extra effort when you can work smart? Import, export, com
bine, and tweak data in bulk with ease.
📊 Customizable Charts and Reports: Access a broad variety of additional charts and generate insightful reports that tell a story.
🗄️ Powerful Navigation Pane: Gain an advantage with the robust Column Manager, Worksheet Manager, and Custom Favorites.
📝 Seven Types of Drop-down Lists: Make data entry a breeze with drop-down lists of various features and types.
🎓 User-Friendly: A breeze for beginners and a powerful tool for experts.
Download Now and Soar Through Time with Excel!
Read More... Free Download... Purchase...
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!
Read More... Free Download... Purchase...
