Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Reset column letters
Message
 
 
To
All
General information
Forum:
Microsoft Office
Category:
Excel
Title:
Reset column letters
Environment versions
Microsoft Office:
Office 2013
Miscellaneous
Thread ID:
01607710
Message ID:
01607710
Views:
47
I have been working with a spreadsheet a company sent me. My goal is to convert the data to DBF/VFP. I plan to do it by converting the spreadsheet to .CSV type and then appending to DBF. I deleted a few un-necessary columns. But then when I save this spreadsheet as .CSV I see that the .CSV text file has "empty" spaces for the columns I deleted. And when I look at the spreadsheet I see some missing columns. For example, I see columns A, B, C, F, G, and so on. So the columns D and E are hidden or somehow still there. How do I reset the spreadsheet to have the column letters all in alphabetical order?

UPDATE. Found solution.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Reply
Map
View

Click here to load this message in the networking platform