Switching Text alignment in spreadsheets

FrankM · Post by **FrankM** » Wed Aug 25, 2010 5:22 am

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?

ben_josephs · Post by **ben_josephs** » Wed Aug 25, 2010 3:32 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.

FrankM · Post by **FrankM** » Sat Aug 28, 2010 8:29 am

In essence I have 115 sets of each of ten form templates. Because of the graphic content all these files were designed in another publishing program. I hope to edit one spreadsheet in the form then use WildEdit to mass update all its child files.

ben_josephs · Post by **ben_josephs** » Sat Aug 28, 2010 9:18 am

You will have to provide a precise description of the format of your data in these files.