How To Search And Replace A Special Character In A String
Hi,
Am Wed, 4 Nov 2015 19:40:04 +0000 (UTC) schrieb tb:
In the Find And Replace window I enter: "^" (no quotes) in the Find
What box and I leave blank the Replace With box. Then I hit the
Replace All button.
for me it works fine if I select the find box and enter ^ and space.
Or put in the find window Alt+0094
Or try:
Sub Replace()
Range("A1:A100").Replace what:="^", replacement:="", lookat:=xlPart
End Sub
Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
|