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)!
ViewImmediate window (Ctrl+G)
Enter
cells.Replace chr(10),"~"
Press Enter when cursor is on the above line!

Regards,
Stefi


€žMike Faulkner€� ezt Ã*rta:

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.

EditReplace Find: [ctrl+j], Replace: ~

"Mike Faulkner" wrote:

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.

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:

EditReplace Find: [ctrl+j], Replace: ~

"Mike Faulkner" wrote:

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.