Assuming the data is in cell A1:
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.
There are currently 9 users browsing this thread. (0 members and 9 guests)