Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
removeing a ' symbol
I am trying to get rid of a ' symbol with out doing it manually. find
replace doesn't work. i tried With ActiveCell.Characters(Start:=1, Length:=1).Delete, but the deletes the ' as well as the next character. any ideas? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
removeing a ' symbol
hi,
i think you have launched yourself into an endless tailchase. I don't know why you are trying to remove the appostophe, but excel may have put it there. excel uses this symble to 1. mark it as text or 2.left justify. In any cell in excel, type anything. if it is a number, no appostrophe. if it is letters, appostrophe and left justified. next center the text. ' changed to ^. next right justify the text. ^ changed to =. excel puts the symble in and there is not much you can do about it. excel does not consider this symbles as a character which is why find and replace didn't work. and why ActiveCell.Characters(Start:=1, Length:=1).Delete seemed to act funny. and even if you did get rid of, excel would put it right back. Why are you trying to remove it? -----Original Message----- I am trying to get rid of a ' symbol with out doing it manually. find replace doesn't work. i tried With ActiveCell.Characters(Start:=1, Length:=1).Delete, but the deletes the ' as well as the next character. any ideas? . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
removeing a ' symbol
How about...
Option Explicit Sub testme() Dim myRng As Range Dim myCell As Range Set myRng = Nothing On Error Resume Next Set myRng = Intersect(Selection, _ Selection.Cells.SpecialCells(xlCellTypeConstants, _ xlTextValues)) On Error GoTo 0 If myRng Is Nothing Then MsgBox "Select some cells with constant text" Exit Sub End If For Each myCell In myRng.Cells myCell.Value = myCell.Value Next myCell End Sub Chris wrote: I am trying to get rid of a ' symbol with out doing it manually. find replace doesn't work. i tried With ActiveCell.Characters(Start:=1, Length:=1).Delete, but the deletes the ' as well as the next character. any ideas? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Type a symbol useing shortcut keys rather the insert a symbol | Excel Discussion (Misc queries) | |||
Euro symbol displays as dollar symbol in Excel | Excel Worksheet Functions | |||
Removeing certian numbers from a row of numbers | Excel Discussion (Misc queries) | |||
Removeing the Grand Total Line when subtotals are removed | Excel Discussion (Misc queries) | |||
I need a symbol but "symbol" in the Insert menu is grayed-out. | Excel Discussion (Misc queries) |