@Pooja Hi
If you want an accurate solution, you start with a sample data, big enough to include all possible patterns of raw data. The initial sample you attached did not contain all possible patterns. =Len() =Mid(,,,) =Left(,,) =Right(,,) =ISERROR() =IF(,,,) =SEARCH(,,,) I suggest you to understand these functions yourself (these are not so difficult and powerful enough handle most of text data manipulations) and try to identify the pattern of your raw data and see if they: 1) BEGIN and/or END with a CERTAIN character(s) (eg "_", "e-" or a <space>) 2) have a FIXED LENGTH (eg: you ALWAYS don't want the first 5 digits of a number) 3) If none of the above are applicable, just see how you identify the information you require from a raw data, and tell the computer to do the same! Well the computer may ask you to give each and every break-up of the procedure! Good Luck :) Hemant Hegde ----------------------------- @All It would be nice if forums like this which have got a big number of experts and professional programmers should help a member to learn rather than being a place where we can post some files of which we forgot the password and and wish someone would break it for us. I had asked for a help about dealing with Importing code to a code module. But I got suggestions about how to search the web better with Google ;) and how to make the query short and interesting [yes! it did help! :)] But I am unhappy that no one bothered to answer my last few posts :( Good Day :) Hemant Hegde --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
