Results 1 to 7 of 7

Thread: [RESOLVED] Select string of data and reformat into single cell/txt file

Threaded View

  1. Aug 1st, 2006, 10:00 AM #1
    heinz1218
    heinz1218 is offline

    Thread Starter
    Member
    Join Date
    Jul 2006
    Posts
    41

    Resolved [RESOLVED] Select string of data and reformat into single cell/txt file

    I have a few hundred lines of data, each containing a 5 or 6 digit number in column C. I need to use them to search in a different program, but i need to have it in the following format:

    111111 OR 222222 OR 33333 OR 444444 etc.
    How would I go about returning the string of the first 5/6 digits, and put that data either into a single cell in the above format (so I could CTRL+C it), or even a .txt file (doesn't matter to me, as long as it's in that format)

    I tried searching online but there doesn't seem to be a good reference site for VBA. Anyone know of one?
    Last edited by heinz1218; Aug 1st, 2006 at 02:38 PM. Reason: resoloved
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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


Click Here to Expand Forum to Full Width