+ Reply to Thread
Results 1 to 3 of 3

Need to SPLIT cell content on to multiple columns using relevant "KEYWORDS" - Urgent

  1. 03-08-2015, 09:05 AM #1
    sshivaji
    sshivaji is offline
    Registered User
    Join Date
    03-08-2015
    Location
    Hyderabad
    MS-Off Ver
    2007
    Posts
    2

    Post Need to SPLIT cell content on to multiple columns using relevant "KEYWORDS" - Urgent

    Hi All,

    I am new to this forum and I have data which needs to be sorted in to multiple columns based on certain keywords (Text before and after them). Kindly help me with this and it is much appreciated, if you guys can help me out with this.

    Attached is the excel with data in first sheet and desired output in second sheet.

    The keywords are: INR, Manufacturer:, Composition:, Form:, Pack Size:, Mfg:


    Thank and Regards,
    Shivaji S
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-08-2015, 09:11 AM #2
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Need to SPLIT cell content on to multiple columns using relevant "KEYWORDS" - Urgent

    Did you tried text to column?
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.
    Reply With QuoteRegister To Reply
  3. 03-08-2015, 09:31 AM #3
    sshivaji
    sshivaji is offline
    Registered User
    Join Date
    03-08-2015
    Location
    Hyderabad
    MS-Off Ver
    2007
    Posts
    2

    Re: Need to SPLIT cell content on to multiple columns using relevant "KEYWORDS" - Urgent

    Hi there, Yes..I have tried the text to columns option and is unable to get the desired output. My query is based on specific "Keywords" and not based on text to column options i.e. symbols, space, tab etc.

    Help me if I am wrong or overlooked the option.

    Regards,
    Shivaji S
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Using "SOLVER" to match two columns, but how to copy it for multiple rows ??? (URGENT)
    By hshahad in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-16-2013, 11:31 AM
  2. [SOLVED] split the cell value with sign "|" to make multiple entries to down
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-26-2013, 03:34 AM
  3. VBA Code- Move/Split cell content based on ","
    By Langer101 in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 12-19-2012, 11:37 AM
  4. [SOLVED] IF cant find selection of multiple keywords return "text"
    By Eagle75au in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-30-2012, 02:52 AM
  5. Split cell values based on "," and "-" and format as shown below
    By Roop in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-22-2012, 12:28 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1