How to split a string based on ":" in MS-Excel? - Super User

My excel column is filled with words like this: 1.) ABC:DCF 2.) DCF:FED. I want to split each word based on " : " and put the result in adjacent columns such that ...

superuser.com