Deleting extra characters?

[KyaPam]

How do I delete these characters (little boxes?) at the end? There has to be an easy way, I have over 7K rows of data although not every row has these. Most have no space between them and the word they follow, others may have a comma.

R/O PE, TONIGHT IF POSSIBLE
CHEST PAIN R/O PE
R/O P.E., SOB
POSSIBLE CHOLECYSTITIS

 

[clayv]

Not knowing what the ASCII char codes for the boxes makes this difficult, but try using the the TRIM function.

If that doesn't work, PM me with a location of a sample file.

 

[plettieri]

Hi KyaPam

You might try this and copy down...

=CLEAN(A1)


plettieri

 

[pgc01]

Hi KyaPam

To remove non printable characters from a string, try:

=CLEAN(A1)

Hope this helps
PGC

 

[KyaPam]

=CLEAN(A1) worked like a charm!
Thanks