+ Reply to Thread
Results 1 to 3 of 3

split cell contents

  1. 05-18-2012, 12:22 AM #1
    bone7890 is offline
    Registered User
    Join Date
    09-08-2010
    Location
    canada
    MS-Off Ver
    Excel 2010
    Posts
    44

    split cell contents

    Hello I have attached a sheet with instruction on exactly what i am trying to accomplish I have tried a few times but i just can't get it.

    Basically what I have is a list of jpeg files that i need to break apart and sort into different rows.

    Any Help would be greatly appreciated
    Attached Files Attached Files
    Last edited by bone7890; 05-18-2012 at 03:22 AM.
    Reply With QuoteRegister To Reply
  2. 05-18-2012, 01:19 AM #2
    NickyC is offline
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,714

    Re: Formula Help

    Hi
    select the cell where you want the data to start typing (B22 in your example) and try this macro

    Sub 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 05-18-2012, 04:36 AM #3
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,834

    Re: split cell contents

    Assuming Data starts from A2 with header in A1.
    Please Login or Register  to view this content.
    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)

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