Live Chat Software by Kayako |
Knowledgebase: Microsoft Excel
Delete 3 beginning characters from a whole column.
Posted by - NA - on 30 March 2006 07:46 AM
|
|
Solution: (You need to divide with 2 columns and delete the first column) 1. Go to Data/Text to Columns 2. Choose Fixed Length 3. Click Next 4. Click on the desired position to cut and next. This will break into 2 columns. 5. Delete first column | |
|
Comments (0)