How to eliminate the Enter key in EXCEL cells in batches

This can be completed by entering the corresponding formula in the auxiliary column. The specific steps are as follows:

Tools/raw materials

EXCEL 2016 version, computer.

1. Open the computer, find and click on the excel2016 spreadsheet software;

2. After opening the excel2016 spreadsheet software, edit any number in cell A2 in order to demonstrate; < /p>

3. After editing the numbers, if you need to cancel in batches, enter the formula in B2: =SUBSTITUTE(A2,CHAR(10),"") and hit the Enter key;

4. After entering the formula and pressing Enter, the characters of the Enter key have been canceled in batches in cell B2.