UNICODE Export with different Separator?

E

Ernst F. Schulz

Hi,

when exporting from EXCEL with file type UNICODE the columns are seperated
with TABS. How can I change this separator to semikolon?

WINDOWS XP Professional SP2 with EXCEL 2002 SP2

Thanks,
Ernst
 
J

Jim Rech

There is no way to change Excel's behavior, so you'd need to use a macro to
create the file you want. I don't have one that creates unicode files
unfortunately.

--
Jim Rech
Excel MVP
| Hi,
|
| when exporting from EXCEL with file type UNICODE the columns are seperated
| with TABS. How can I change this separator to semikolon?
|
| WINDOWS XP Professional SP2 with EXCEL 2002 SP2
|
| Thanks,
| Ernst
|
|
 
Top