+ Reply to Thread
Results 1 to 4 of 4

Extract data after space

  1. #1
    Registered User
    Join Date
    01-29-2007
    Posts
    6
    Another question as well. If i wanted to extract data from cell that has the following information but only need the right side after the : and space.. i need to write this into my code.. any ideas?

    Example

    Data: Test
    Data Data: testing
    License Number: Testing
    date: 3/15/08

  2. #2
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591
    Hi

    Is the data all in one cell, or is it split across 2 cells?

    rylo

  3. #3
    Forum Contributor
    Join Date
    02-27-2008
    Posts
    764

    formula

    HI
    If it is in a single cell
    B1 = Mid(A1, search(":",A1,1)+2,100)
    Ravi

  4. #4
    Registered User
    Join Date
    01-29-2007
    Posts
    6
    it's in one cell and i need to copy just the text after the ": " I am trying Ravi's code now

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1