Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Remove apostrophe
Where apostrophes ( ' ) appears in a string can it be removed with a
formula? |
#2
|
|||
|
|||
=SUBSTITUTE(A1,"'"," ")
This will replace the apostrople's in A1 with spaces......... Vaya con Dios, Chuck, CABGx3 "Pat" wrote in message ... Where apostrophes ( ' ) appears in a string can it be removed with a formula? |
#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. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Pat" wrote in message ... Where apostrophes ( ' ) appears in a string can it be removed with a formula? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
remove last three characters of cell | Excel Discussion (Misc queries) | |||
Remove the apostrophe (') in Excel cell text values | Excel Discussion (Misc queries) | |||
Remove link fr a column of entries | Excel Discussion (Misc queries) | |||
Remove link fr a column of entries | Excel Discussion (Misc queries) | |||
Remove link fr a column of entries | Excel Discussion (Misc queries) |