Excel 2002

J

Jim K.

I importing a text block and want to replace nonprinting
character (returns) with a space
 
P

Paul

Jim K. said:
I importing a text block and want to replace nonprinting
character (returns) with a space

Use Replace on the edit menu. In the "Find what" box you hold dowm Alt
whilst pressing 0010 on the keypad at the right of the keyboard. It will
look as though there is nothing there, but Replace will work.
 
Top