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