Feed
 

Text from Numbers

Avatar John Surtees
I need to take some text from a spreadsheet and create Tab delimited text. Using Excel, I am able to 'Save as' and then choose 'tab delimited text'. Has anyone found if its possible using Numbers. Is there a hidden export feature that I'm missing?

Re: Text from Numbers

Avatar Mick Burrell
You'd need to test in the App that will be opening the TAB file but it may work with Export to CSV. If it doesn't, you could try loading the CSV into Text Edit and use Find & Replace to find commas and replace with tabs. (To enter a tab character in the replace field, press alt+tab)

Re: Text from Numbers

Avatar John Surtees
Thanks Mick, I found that both TAB and CSV files open fine in Nisus. It has a very easy to use Find and Replace facility and we have been able to carry out just what we needed to do.
 
Feed