yes thats a better idea rather than writing a macro... U shd sometimes try to do simple things simply!!
On Thu, Dec 11, 2008 at 9:21 PM, Manisha Jain <manishakothari.j...@gmail.com > wrote: > U can also try without the macro... > > go to Data -> Text to columns -> Delimited -> next -> check the box beside > comma ->next -> next-> ok > > > On Thu, Nov 20, 2008 at 8:44 PM, Tom Jeffries <tjeff...@gmail.com> wrote: > >> The attached Workbook contains a macro(SplitCol) that does what you >> describe. If you have any questions let me know. >> Tom >> >> On Wed, Nov 19, 2008 at 10:13 AM, Mike <mikhail_bogo...@hotmail.com>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 >>> >>> >>> >>> >>> >>> >>> >> >> > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
