Formula help

kpierson109

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.

Paul Newcome

In that case you would use

="kc" + RIGHT([Column Name]@row, LEN([Column name]@row) - (FIND("-", [Column Name]@row) + 2))

Paul Newcome

So are you looking for two different formulas? You outline above two separate outputs.

"kccard"

vs

"kc" and the word after the hyphen

kpierson109

I need a formula for the second. I will have cells that have any word after the hyphen.

"Knowledge Card - ______"

Paul Newcome

In that case you would use

="kc" + RIGHT([Column Name]@row, LEN([Column name]@row) - (FIND("-", [Column Name]@row) + 2))

kpierson109

Thank you!

Paul Newcome

Happy to help. 👍️