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
(137 vote(s))
This article was helpful
This article was not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
Help Desk Software by Kayako Fusion