Need to remove word ‘Keyword’ from field ‘formula test’.
I would like to have a separate column (Mostly a formula column) that would give me output with no word ‘Keyword’ in the list.
Using substitute only
But I didn’t had to create a formula (i don’t know how to). I found a few on the internet that I applied to other columns and somehow my problem got solved.