Announcement

Collapse
No announcement yet.

Unconfigured Ad Widget

Collapse

Function: Return Text After Specified Character

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

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

    Assuming the data is in cell A1:

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

    Comment


    • #3
      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

      Comment

      Trending

      Collapse

      There are no results that meet this criteria.

      Working...
      X