Dear all
I am using Vista with Office 2007. I am getting error message When I save or save as any document<http://www.pcreview.co.uk/forums/thread-2417641.php#>I am getting the following message: "Your changes could not be saved to XXX because of a sharing violation. Excel <http://www.pcreview.co.uk/forums/thread-2417641.php#> has created a temporary file...." and it creates new files with new names every time. Nad changes in new files are not saved. Can any body help me in this regard. amit On Wed, Nov 19, 2008 at 8:43 PM, Mike <[EMAIL PROTECTED]> wrote: > > Hi, > i have a data populated into a column with company name and other data > devided by a comma. > > So it looks something like: > > AAA Inc., Series1 > ABCD Ltd., Class 99 > 1234 Bank, Some Data 999 > and so on > > How could i put everything to the left from comma to column B and > everything to the right from comma to column C? > Thanks very much. > Mike > > > > > > > > -- Amit Arora --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---