+ Reply to Thread
Results 1 to 2 of 2

Extract text to the right of ":"

  1. #1
    Forum Contributor
    Join Date
    12-22-2012
    Location
    Asia
    MS-Off Ver
    Microsoft 365
    Posts
    234

    Extract text to the right of ":"

    Hi,

    Could you pls help me with the formula to extract text to the right of the ":"?

    thanks

    C:VNP
    C:ABT
    C:ADN
    C:AEF
    C:ACST
    C:AT
    C:AAV
    C:ARE
    C:AEZS
    C:AFE
    C:AOI
    C:AFN
    C:ACR.UN
    C:AGF.B

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,604

    Re: Extract text to the right of ":"

    Have a look at the MID() function.
    Ben Van Johnson

+ 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: 4
    Last Post: 06-11-2017, 02:03 PM
  2. Replies: 1
    Last Post: 08-15-2014, 06:00 AM
  3. [SOLVED] EXTRACT TEXT "SHM" or "SHGB"
    By Jhon Mustofa in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-29-2014, 07:57 AM
  4. Trying to extract "Text" inbetween ":" and ","
    By Paulzr27 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-06-2013, 05:48 AM
  5. Replies: 1
    Last Post: 10-22-2012, 09:38 AM
  6. How can i copy value from "HTMLText"(EMBED("Forms.HTML:Text","")),using Macro
    By andrewyang in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-18-2010, 12:47 AM
  7. Replies: 5
    Last Post: 09-19-2008, 04:02 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1