RE: $$Excel-Macros$$ Text to collumn
Dear Anand Thanks for explanation and really nice way of explain shrinivas > Date: Thu, 14 Oct 2010 23:58:15 -0700 > Subject: Re: $$Excel-Macros$$ Text to collumn > From: anand...@gmail.com > To: excel-macros@googlegroups.com > > 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 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 > > 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 > > > 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 ti
Re: $$Excel-Macros$$ Text to collumn
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 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 > 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 > > 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
Re: $$Excel-Macros$$ Text to collumn
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 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 > 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 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 > > > > -- > > -- > 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 > > -- > > -- > 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 > -- -- 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
RE: $$Excel-Macros$$ Text to collumn
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 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 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 -- -- 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 -- -- 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
Re: $$Excel-Macros$$ Text to collumn
gb On Wed, Oct 13, 2010 at 2:18 PM, kaza deepu wrote: > Hi Kashan Abbas, > > Find attached it may helps you. > > > On 10/13/10, Kashan Abbas 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 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 >> >> > > > -- > Regards, > Dileep Kumar Kaza > > Duty is God Work is Worship > > -- > > -- > 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 > -- -- 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
Re: $$Excel-Macros$$ Text to collumn
Hi Kashan Abbas, Find attached it may helps you. On 10/13/10, Kashan Abbas 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 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 > > -- Regards, Dileep Kumar Kaza Duty is God Work is Worship -- -- 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 CODE(1).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet