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