Office software is closely linked to the PDF,the PDF is also must have to control!
Set home Page Add to Favorites
|
Method 5: Remove Hidden characters and spaces if the data arranged in a single row or line, this method is best. Using TRIM and CLEAN function to remove files with the extra spaces and non-printing characters. The following examples assume that data is located in column A, row 1 ($ A $ 1). Want to delete hidden characters and spaces, please follow these steps: 1. in the A column insert the right one. To do this, click "B", then "Insert" menu, click "out." 2. in the insert out of the first cell (B1), type the following: $ B $ 1: = VALUE (TRIM (CLEAN (A1 ))) 3. In column B, select column A contains the cell data of all cells in the right side. 4. In the "Edit" menu, point to "fill", and then click "down." A new columncolumn contains the value of the Chinese version. 5. selected the same area, click the "Edit" menu "Copy." 6. click cell A1, and then "Edit" menu click "Paste." in the "Paste", click the "value", and then click "OK" will be converted to the value of re-paste it into the A list of the top. 7. delete column B. method is specific to operate, click the column, and then click the "Edit" menu of "Delete." A column of text in digital format has now become. attention to this method may not remove all non-printing characters blank. For example, the whitespace characters Chr $ (160) does not delete.
method 6: the use of "sub-text of" command if the data arranged in a single column, this method is best. The following examples assume that data is located in column A, row 1 ($ A $ 1). To use this example, follow these steps: 1. Select the text that contains a cell. 2. In the "Data" menu, click "breakdown." 3. In the "original data type", click "separator", then click "Next." 4. In the "delimiters", click to select "Tab key" check box, and then click "Next." 5. in the "data format", click "General." 6. Click the "Advanced", set the corresponding "separator 10" and "separator 1000." Click "OK." 7. Click "Finish." text is converted to digital now. Method 7: Using Microsoft Visual Basic for Applications (VBA) process to create a VBA macro to the selected cell or selected range in the number of re-enter. Specific steps are as follows: 1. Select the cells to convert. 2. If you have not changed the number of cell format, in the "Format" menu, click "cell", and then click the "digital" tab to change the number format of cells. 3. by combination of Alt + F11 to start Visual Basic Editor. 4. In the "Insert" menu, click "modules." 5. the following macro code in the new module, type: Sub Enter_Values () For Each xCell In Selection xCell.Value = xCell.Value Next xCell End Sub 6. by Alt + F11 to switch to Excel. 7. If you have not selected to convert the cell, it will select it. 8. In the "Tools" menu, point to "Macro", and then click "macro." in the "Macro name" list, click "Enter_Values". Click "Run." |
