Formula help

I want text to generate in cell based off of another cell. I want cell with text "Knowledge Card - Access" to generate "kccard" in another cell.

I want Knowledge Card to abbreviate to "kc" and I want the word after the hyphen no matter what the word is to appear right after.

Best Answer