Hai Pradeep, select the area then
Data -> Text to columns -> Deliminated -> other option put "-" then u can get data in individual cells if you want to add use concatenate () to add columns, which all are required data for you. regards siva On Sun, Oct 19, 2008 at 4:45 PM, Mattathil M. Pradeep <[EMAIL PROTECTED]>wrote: > Dears.. > > > > How to copy particular data from one cell ? attached excel sheet for your > reference. > > > > Thanks in advance > > PRADEEP > > > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
query with solution.xls
Description: MS-Excel spreadsheet
