Results 1 to 4 of 4

VBA for extract #s from diff. strings of data

Threaded View

  1. #1
    Registered User
    Join Date
    08-19-2010
    Location
    new york
    MS-Off Ver
    Excel 2010
    Posts
    97

    VBA for extract #s from diff. strings of data

    I'm attaching an example. column A shows what the data looks like, it will always start in A12 (if that makes a difference), and B and C show what I need from the random string of data in A. I tried text to column and what happens is that for column B i always get stuck with the "S:" and in column C i always get stuck with the color description after the 3-digit color code.

    I feel like i need coding or possibly a mega formula, but i'm having trouble, please help.

    the style # will always come after the "S:" but sometimes it will be 6 digits, and sometimes 7, and the color code will always be 3 digits.
    Attached Files Attached Files
    Last edited by juniperjacobs; 02-05-2011 at 01:40 PM. Reason: solved

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1