Function: Return Text After Specified Character

[tblondet]

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

[Seti]

Assuming the data is in cell A1:

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

[tblondet]

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

Best,

Thomas