Saving a tab separated file in Excel without quotes
To save Excel file into tab separated file (without quotes added):
- In Excel, press CtrlA to select all
- Press CtrlC to copy
- Open Notepad, press CtrlV to paste
- Press CtrlS to save and it is done
Find & Replace this: ("
)
With a null value: ()
Manually.
Then,
Find & Replace 'All' of this (""
)
With this: ("
)