Saturday, October 6, 2012

Removing enters from excel

Just to remind myself when someone delivers crappy import xls files:

1) Press CTRL+H (i.e. shortcut for Find and Replace)
2) Click in the ‘Find what‘ field, hold down the ALT key and type 0010;. It may not seem like anything happened but you actually entered an invisible line break character
3) At this point you can choose to Replace All.

No comments:

Post a Comment