Current location - Quotes Website - Signature design - How to delete the comma before ID number in EXCEL table?
How to delete the comma before ID number in EXCEL table?
1. First, we open the form with the ID number.

2. Find the "data" at the top of the table.

3. Click on the data to find the breakdown.

4. Click the column, select the delimiter, and then click Next.

5. Select' after the text identifier, and then click Next.

6. Select the text and click Finish. The comma in front of the ID card in the form will be eliminated.