Is it possible to use WildEdit to search multiple files each embedded with identical Excel spreadsheets and switch identical blocks of cells from left aligned to right aligned text?
If so, how please?
Switching Text alignment in spreadsheets
Moderators: AmigoJack, helios, bbadmin, Bob Hansen, MudGuard
-
- Posts: 2456
- Joined: Sun Mar 02, 2003 9:22 pm
Excel stores its data in a proprietary format, which changed with Excel 2007. Can you not make these changes with Excel itself, perhaps with the help (or, rather, the hindrance) of a VBA script? If not, and if you precisely describe the format of your data, it may be possible to find a way to do this with WildEdit.
-
- Posts: 2456
- Joined: Sun Mar 02, 2003 9:22 pm