How to replace the character "?" in a cell??

[fulltime]

I read from VB help file that to replace question mark, "?", we enclose it in brackets since "?" is a special character. However, i tried (?) or [?] but it cant work?

Anyone can help??

Thks

FT

 

[HaHoBe]

Hi, FT,

maybe just do what is written in the help files?

Option Explicit

Sub FT()
Dim lngCounter As Long
Dim strValue As String
strValue = ActiveCell.Value
For lngCounter = 1 To Len(ActiveCell.Value)
  If Mid(ActiveCell.Value, lngCounter, 1) Like "[?]" Then
    Mid(strValue, lngCounter, 2) = "FT"
    ActiveCell.Value = strValue
  End If
Next lngCounter
End Sub

Ciao,
Holger

 

[___]

=substitute(a1,"?","")

 

[fulltime]

thks brothers, it works..