Where apostrophes ( ' ) appears in a string can it be removed with a formula?
C CLR Sep 11, 2005 #2 =SUBSTITUTE(A1,"'"," ") This will replace the apostrople's in A1 with spaces......... Vaya con Dios, Chuck, CABGx3
=SUBSTITUTE(A1,"'"," ") This will replace the apostrople's in A1 with spaces......... Vaya con Dios, Chuck, CABGx3
R Ragdyer Sep 11, 2005 #3 You do realize that you will have a formula that returns a string, and not the actual string itself. As an option, you might think about using <Edit> <Replace> instead, where there is no formula to be eliminated, if that might become necessary.
You do realize that you will have a formula that returns a string, and not the actual string itself. As an option, you might think about using <Edit> <Replace> instead, where there is no formula to be eliminated, if that might become necessary.
