Excel doesn't always treat tabs as column separators, it uses commas by default. Is the document you're editing a CSV or XLS?
Often when I try to put in data that has tab/comma separation into LibreOffice, it will prompt me and ask what characters is the column separator. I don't use Excel on Mac so I'm not sure if it can give you those options. On Dec 5, 9:38 am, Dick Griffin <[email protected]> wrote: > I'm doing some editing of an Excel doc, using the find and replace > feature to remove some existing tabs that bracket an end line > character, with the intent to re-import the file into Excel as > distinct columns. In BBEdit, my edit's go just fine, (using the > highlight -past to find-replace) and the new tabs I create appear to > be the same as the original documents existing tabs, yet when I > retrieve the txt file back into Excel, the tabs I created in BBEdit do > not act like the original tabs in the original document, and do not > trigger new columns. > > What am I not doing right? > > Thanks in advance for your time. > Dick Griffin -- You received this message because you are subscribed to the "BBEdit Talk" discussion group on Google Groups. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at <http://groups.google.com/group/bbedit?hl=en> If you have a feature request or would like to report a problem, please email "[email protected]" rather than posting to the group. Follow @bbedit on Twitter: <http://www.twitter.com/bbedit>
