Software Find And Replace Line Breaks In Excel

Find And Replace Line Breaks In Excel

| Written by some jerk | Print | Email | Hits: 140
 
  1. Select the cells you want to search.
  2. Hit CTRL+H. ...
  3. In the Find What dialog box hit CTRL+J (it will appear blank- that is ok).
  4. In the Replace With dialog box just hit the Space bar to enter a space.
  5. Hit Find Next or Replace All to find your cells with to find all of your cells with the line breaks.