Binary Squares
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.
|