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.
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.
Have you tried SUBSTITUTE()
?
Have you tried SUBSTITUTE()
?
I found the solution.
Thanks for responding.
I found the solution.
Thanks for responding.
What is the solution?
What is the solution?
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.