Remove unusual text/Keep text that has A-Z

A

Alex

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…
 
S

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

[email protected]
[email protected] with @tiscali.co.uk
 
B

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)
 
Top