Remove unusual text/Keep text that has A-Z

[Guest]

I download a file that contains text as you see below. I need to remove the
.... The problem is that the "." is not really a "." its "..." as one. So if
you replace or subsitute all "." it will not replace that. You can see what
I mean if you backspace once it will delete all "...". Its as if its one
character. Is there a way to remove this unusual character, like maybe just
keep all letters?

NICE…
NICF…
NICI…
NICJ....
NICK…
NICP…

 

[Sandy Mann]

Char(133) is ... so try entering 0133 with the Alt key pressed in the Find
What of the Replace dialog box using the number keypad not the keys at the
top of the keyboard.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Bob Phillips]

Selection.Replace What:=Chr(133), Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False


--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)