Hi Kendall, Thanks for the response. I'm opening an HTML doc in Excel (for Mac), saving it as Tab Delimitated , Editing it in BBEdit, saving it, and re-opening it in Excel Mac.
I tried to save out of Excel as CVS, edit, and reopen and lost all of the hard returns. I just bought BBEdit because I had the same problem in TextWrangler, and couldn't figure it out. Am new to BBEdit, today. Happy Holidays, Dick Griffin On Dec 5, 2011, at 10:42 AM, Kendall Conrad wrote: > 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> -- 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>
