Binary Squares

[Mike Faulkner]

OS: Windows XP
App: Excel 2003

I have been given some data exported from an SQL database. When opened in
Excel a cell contains Binary Squares or hard Returns (CHR10). I need to
convert these ASCII Chars to say a tilde (~).

Any help would be greatly appreciated.

 

[Stefi]

Open VBA (Alt+F11)!
View>Immediate window (Ctrl+G)
Enter
cells.Replace chr(10),"~"
Press Enter when cursor is on the above line!

Regards,
Stefi


„Mike Faulkner†ezt írta:

 

[Lori Miller]

Edit>Replace Find: [ctrl+j], Replace: ~

 

[Stefi]

I began to be glad to find a direct method to insert a non-printable
character in Replace dialog, but it failed for me. The only way I could
insert a chr(10) character in the Find field was to enter it in a cell and
Copy/Paste it in the Find field.

How did you do that?

Stefi


„Lori Miller†ezt írta:

Edit>Replace Find: [ctrl+j], Replace: ~

OS: Windows XP
App: Excel 2003

I have been given some data exported from an SQL database. When opened in
Excel a cell contains Binary Squares or hard Returns (CHR10). I need to
convert these ASCII Chars to say a tilde (~).

Any help would be greatly appreciated.