export txt file from excel help

[paul3200]

i have tried (and succeeded) to export a txt file from excel 2010 but each column is separated by a tab and i want it to be separated by a "|" character so it can be used in a program i have edited

thanks

 

[clunkfish]

You could open the txt file in Word, then do a Find and Replace. The way to find a tab is to use ^t in the find field, and obviously put | in the replace field. Hit "replace all", then make sure to save it as a txt file