Hi, The solution provided does not require a VBA code. Inbuilt facilities of Excel can do that as well. There's a feature called text to Columns in data tab in 2007 version and in data menu in previous ones. Select the first column select Text to Colums. Click on Delimited in option button click next in the menu provided on dialog box tick mark Tab and Space click on next and finish. Excel will automatically separate each value based on space into different cells. Hope that helps
Warm regards, Anand Kumar On Oct 14, 5:16 pm, SUMIT VYAS <svyas0...@gmail.com> wrote: > Mr. Naveen > > Please explain to Mr. Shrinivas. > > i am request please provide vba code. > > Regards > > Sumit > > On Thu, Oct 14, 2010 at 5:17 PM, shrinivas shevde > <shrinivas...@hotmail.com>wrote: > > > Please Can I know how to do it? > > > shrinivas > > > ------------------------------ > > Date: Thu, 14 Oct 2010 13:16:47 +0530 > > Subject: Re: $$Excel-Macros$$ Text to collumn > > From: nsharma110...@gmail.com > > To: excel-macros@googlegroups.com > > > It is resolved. Please have a look > > > Naveen > > 98219 80081 > > > On Wed, Oct 13, 2010 at 11:59 AM, Kashan Abbas <kashanabbas...@hotmail.com > > > wrote: > > > Dear All, > > > I have extracted a report from sap .The first column has been merged with > > multiple information for which i need separe column. > > > The detail of information in first column is given as first few character > > represent product name ,then SAE level e.g (SAE 40,SAE 10W90) and then > > packing size e.g (4L Can and 205LDrum) .I just want to have seprate collumn > > for each given information.I am using text to collumn option but could not > > able produce desired output. > > > For you working file have been attached.Please suggest me best possible > > solution on urgent basis. > > > Need of your usual cooperation . > > > Regards , > > > Kashan Abbas . > > > -- > > > ---------------------------------------------------------------------------------- > > Some important links for excel users: > > 1. Follow us on TWITTER for tips tricks and links : > >http://twitter.com/exceldailytip > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > > > <><><><><><><><><><><><><><><><><><><><><><> > > Like our page on facebook , Just follow below link > >http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&... > > > -- > > > ---------------------------------------------------------------------------------- > > Some important links for excel users: > > 1. Follow us on TWITTER for tips tricks and links : > >http://twitter.com/exceldailytip > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > > > <><><><><><><><><><><><><><><><><><><><><><> > > Like our page on facebook , Just follow below link > >http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&... > > > -- > > > ---------------------------------------------------------------------------------- > > Some important links for excel users: > > 1. Follow us on TWITTER for tips tricks and links : > >http://twitter.com/exceldailytip > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > > > <><><><><><><><><><><><><><><><><><><><><><> > > Like our page on facebook , Just follow below link > >http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&... -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts