Binary Squares

  • Thread starter Thread starter Mike Faulkner
  • Start date Start date
M

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.
 
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:
 
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: ~

Mike Faulkner said:
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.
Click to expand...
Click to expand...
 
Back
Top