Hi,
I have a column containing text lables in the form:
Country A: Apples
Country B: Oranges
Can someone please suggest a formula that will simplify the above to:
Apples
Oranges
I guess that a function like SUBSTITUTE might work but I'm not sure how to deal with the different countries, represented by A and B in my example.
Thanks!
Bookmarks