| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
detect and remove apostrophe
Oops again! Sorry! Range("a1") = Replace(ActiveCell, "'"' "") "Toppers" wrote: If Left(ActiveCell, 1) = "'" Then MsgBox " Apostrophe detected " Range("a1") = Replace(ActiveCell, "'", "") ' Or Range("a1") = Right(ActiveCell, Len(Range("a1")) - 1) MsgBox " Apostrophe removed " End If "ilyaskazi" wrote: I want Apostrophe = "*::'::*" and not comma = "*::-,-::*" -- ilyaskazi ------------------------------------------------------------------------ ilyaskazi's Profile: http://www.excelforum.com/member.php...o&userid=23969 View this thread: http://www.excelforum.com/showthread...hreadid=395245 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove Apostrophe from end of number | Excel Discussion (Misc queries) | |||
| Remove Trailing Apostrophe | Excel Discussion (Misc queries) | |||
| how to remove the apostrophe | Excel Discussion (Misc queries) | |||
| Remove apostrophe | Excel Worksheet Functions | |||
| Remove Formatting Apostrophe | Excel Programming | |||
Threaded Mode
