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

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


    Assuming the data is in cell A1:


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

  • 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

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!