+ Reply to Thread
Results 1 to 2 of 2

getting spacific numbers from a cell

Hybrid View

komet122 getting spacific numbers from... 03-30-2016, 12:18 PM
AlKey Re: getting spacific numbers... 03-30-2016, 12:32 PM
  1. 03-30-2016, 12:18 PM #1
    komet122 is offline
    Registered User
    Join Date
    03-30-2016
    Location
    Bluffton,Indiana
    MS-Off Ver
    2013
    Posts
    7

    getting spacific numbers from a cell

    I need to pull this into 4 cells 2510/2402 so it will look like the attachment i included.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-30-2016, 12:32 PM #2
    AlKey is offline
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: getting spacific numbers from a cell

    Enter formula in D4 and pull formula to the right

    Formula: copy to clipboard 
    =--MID(SUBSTITUTE( REPLACE( REPLACE($B4,3,,"/"),9,,"/"),"/",REPT(" ",50)),50*(COLUMNS($B:B)-1)+1,50)


    or this short version

    Formula: copy to clipboard 
    =--MID(SUBSTITUTE($B4,"/",""),COLUMNS($B:B)*2-1,2)
    Last edited by AlKey; 03-30-2016 at 12:44 PM.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne
    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] Select Spacific sheets...
    By pwnyadav007 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-12-2014, 03:59 AM
  2. Adding Spacific Date Range
    By rmorganpier45 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-19-2014, 09:45 PM
  3. Using Index and Match to get spacific information
    By komet12 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-05-2014, 10:01 AM
  4. issue converting date to a spacific format
    By komet12 in forum Excel General
    Replies: 2
    Last Post: 12-12-2013, 10:04 AM
  5. Parcing spacific data from a cell
    By oneyejack in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-14-2007, 11:17 PM
  6. how do i get a pop up with reminders of things to do at spacific .
    By abc answering service in forum Excel General
    Replies: 2
    Last Post: 12-27-2005, 01:35 PM
  7. Help with VBA code, making it spacific to one workbook
    By polska2180 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-27-2005, 02:47 PM

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