gb On Wed, Oct 13, 2010 at 2:18 PM, kaza deepu <[email protected]> wrote:
> Hi Kashan Abbas, > > Find attached it may helps you. > > > On 10/13/10, Kashan Abbas <[email protected]> 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 [email protected] >> >> <><><><><><><><><><><><><><><><><><><><><><> >> 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 [email protected] > > <><><><><><><><><><><><><><><><><><><><><><> > 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 [email protected] <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
