![]() ![]() For instance, some people have reported better results in Excel's guesses if you format the source column with a Courier font before doing the conversion. There are a few things you can try, however, that may help. There is no way to stop Excel from guessing when trying to parse fixed-width data. She wonders if there is a way to clear all of the suggested break lines at once so she can enter the break lines manually where she wants them. She needs to use the fixed-width parsing in the tool, and when she runs the wizard Excel looks at the source data and suggests places where the data should be "broken." Milda finds this annoying, as Excel normally guesses wrong. Milda needs to use Excel's Convert Text to Columns Wizard quite often for one of her work projects. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |