Tuesday, December 8, 2009

Search Carriage Return and Line Feeds Character on Excell

Posted by Aries Wandari

          LSMW will produce error if text data transported have carriage return character. We have to replace it with another character. But, how to search that character on text. I’m using ms excell to search and replace the character. On the search/replace window, hold down alt and type 013, release alt key. Carriage return key will be found/replaced. For line feeds character, type 010.
In excell, long text with carriage return will go across the screen. To view them as multiple line, go to Format Cells menu, tab Alignment, tick the Wrap text check box.
image

0 comments:

Post a Comment