Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Mar 2012
    Posts
    13
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Extract from cells to rows

    Hi
    This is my first post and i need some help.

    I have certain content in cell a1 which needs to be extracted and put on to adjacent rows. something like text to column functionality in excel. The problem however is that the criteria to extract information is basis certain 'headers' (which are always in bold) in the cell. This i need to do for the whole list . The content beside each 'header' has to fall under respective column heads.
    please refer to attachment to get an idea.


    Title: XXX*Designation: XX*JOB: 1969**XOB: Sheykhan Ville, Tkkwti Area, Tygun District**Good quality a.k.a.: Naela Del Jaoba**Bow quality a.k.a.: na**Nationality: na*Passport no.: na**Iationa identification no.: na**Address: na**Visted on: 4 Nov. 2011***Other information: Downunder is frequent and is attached to cells

    Thanks
    Attached Files Attached Files

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,826
    Thanks
    136
    Thanked 482 Times in 459 Posts
    Hi swingy

    Welcome to the lounge.
    Your problem can be solved using formulas and VBA.
    see attached file.
    I have defined a set of formulas in row1 which are copied to the relevant data record rows.
    The formulas are then converted to 'values'.
    Click the button to see it work.

    To make this work I had to 'fix' some discrepancies in your 'header' cells.
    The ones I changed are in pink.
    These were changed to EXACTLY correspond to the bold entries in column A.

    You can hide row 1 for 'tidyness'.

    zeddy
    Attached Files Attached Files

  3. The Following User Says Thank You to zeddy For This Useful Post:

    swingy (2012-03-29)

  4. #3
    New Lounger
    Join Date
    Mar 2012
    Posts
    13
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Hi Zeddy ,

    thanks a lot for this amazing solution !!! works like a charm ! it is a learning for me .. Thank You ..thank you thank you !

Posting Permissions

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