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
-
In that case you would use
="kc" + RIGHT([Column Name]@row, LEN([Column name]@row) - (FIND("-", [Column Name]@row) + 2))
Answers
-
So are you looking for two different formulas? You outline above two separate outputs.
"kccard"
vs
"kc" and the word after the hyphen
-
I need a formula for the second. I will have cells that have any word after the hyphen.
"Knowledge Card - ______"
-
In that case you would use
="kc" + RIGHT([Column Name]@row, LEN([Column name]@row) - (FIND("-", [Column Name]@row) + 2))
-
Thank you!
-
