That would be awesome but the boxes (char127) are mixed through out my data.
Thanks

"T. Valko" wrote:

Oh, I see.

When I entered this FORMULA:

="MN"&CHAR(127)&987

It worked. However, when I type in MN<ALT 127987 it does not work.

This works (assumes the char 127 is always in the 3rd position):

=REPLACE(A5,3,1," ")

Biff

"rtremblay" wrote in message
...
Does not work see previous reply.

"T. Valko" wrote:

Can't you just use:

=SUBSTITUTE(A5,CHAR(127)," ")
=SUBSTITUTE(A5,CHAR(127),CHAR(32))

Biff

"rtremblay" wrote in message
...
When I use the formula to get rid of char 127 I want to replace it with
a
space. Is there a way to modify the formula below to accomplish this.
Currently this takes char 127 out then replaces it with char 7 then the
clean
function removes char7.

=CLEAN(SUBSTITUTE(A5,CHAR(127),CHAR(7))) Replaces the nonprinting DEL
character (ASCII value of 127) with a BEL character (ASCII value of 7)
by
using the SUBSTITUTE function, and then removes the BEL character from
the
string "MN987" (MN987)