Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: Function: Return Text After Specified Character

  1. #1
    Join Date
    27th October 2006
    Posts
    35

    Function: Return Text After Specified Character

    Hi,

    I am trying to build a formula that return what is after ":"
    For example, in a cell, I have NASDAQ:MSFT and I want another cell to return MSFT.
    I tried to use the function FIND combined with a LEFT or RIGHT but I could not have it work.

    Any help would be greatly appreciated.

    Regards,

    Thomas

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    3rd June 2004
    Location
    CT
    Posts
    611

    Re: Whithin A String, Return The String After The Sign ":"

    Assuming the data is in cell A1:

    =RIGHT(A1,LEN(A1)-FIND(":",A1))

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    27th October 2006
    Posts
    35

    Re: Whithin A String, Return The String After The Sign ":"

    Thank you very much Seti for your quick answer - What I was missing was the LEN() !

    Best,

    Thomas

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Return All X Character Combinations
    By bugmenot2 in forum EXCEL HELP
    Replies: 4
    Last Post: February 12th, 2008, 07:10
  2. Return Number Before Alpha Character
    By thelarster in forum EXCEL HELP
    Replies: 3
    Last Post: February 12th, 2008, 06:44
  3. Return Value If Specific Character In Cell
    By adamlesper in forum EXCEL HELP
    Replies: 1
    Last Post: August 31st, 2007, 12:59
  4. Return Text After Certain Character
    By zotee98 in forum EXCEL HELP
    Replies: 2
    Last Post: August 22nd, 2007, 01:21
  5. Force Text Function To Return Number
    By CSMRock in forum EXCEL HELP
    Replies: 6
    Last Post: December 15th, 2006, 01:43

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
  •  
porno