If the colon is always present, then this should work:
If not I'd probably use an if statement so the original string could be retained if there is no colon present (otherwise a null value is the result).
Thanks Noah, worked like a charm!
And in the instances where the cell did not have a colon, the original text came through so no need for an if statement...at least not that i can tell.
Again thanks so much!
Great! I must have done something funny to my test data, glad it worked for you.