+ Reply to Thread
Results 1 to 6 of 6

Extract strings from first dot find..???

  1. #1
    Forum Contributor
    Join Date
    01-22-2013
    Location
    Pekanbaru, Indonesia
    MS-Off Ver
    Excel 2013 (Inc. Power Query)
    Posts
    1,072

    Extract strings from first dot find..???

    hello all,

    I have values in a column as, start from a1 :

    a1-------sebidang tanah, luas 300 m2. SHM nomor 23
    a2-------tanah seluas 786 m2. SHGB No.45
    a3-------tanah seluas 200 m2. AJB Nomor 568/KN/1999

    i want to output :

    b1-----SHM nomor 23
    b2-----SHGB No.45
    b3-----AJB Nomor 568/KN/1999

    for your help is greatly appreciated.

    jhon mustofa

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,136

    Re: Extract strings from first dot find..???

    hi jhon mustofa. try:
    =MID(A1,FIND(".",A1)+2,LEN(A1))

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,256

    Re: Extract strings from first dot find..???

    Try this, copied down...
    =MID(A1,SEARCH(".",A1,1)+2,99)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    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: Extract strings from first dot find..???

    Or this:

    =REPLACE(A1,1,FIND(".",A1)+1,"")
    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

  5. #5
    Forum Contributor
    Join Date
    01-22-2013
    Location
    Pekanbaru, Indonesia
    MS-Off Ver
    Excel 2013 (Inc. Power Query)
    Posts
    1,072

    Re: Extract strings from first dot find..???

    it's very simple query..100% worked..

    many thanks...

  6. #6
    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: Extract strings from first dot find..???

    You're Welcome and thank you for your feedback!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 07-15-2009, 10:59 AM
  2. extract numbers out of strings.
    By mikeburg in forum Excel General
    Replies: 3
    Last Post: 08-06-2008, 04:52 PM
  3. How to find and extract numbers that may be present in lengthy text strings
    By Langkawi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-15-2007, 03:17 PM
  4. How to find number of pairs of strings from list of strings?
    By greg_overholt in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-27-2006, 06:45 PM
  5. [SOLVED] HOW TO EXTRACT STRINGS FROM CELLS
    By vidhya in forum Excel General
    Replies: 2
    Last Post: 11-17-2005, 08:45 AM

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