User Tools

Site Tools


excel

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
excel [2019/10/10 10:06]
zeppo
excel [2020/07/07 16:40] (current)
zeppo [Replace a character with a carriage return]
Line 1: Line 1:
 + ===== Replace a character with a carriage return =====
 +
 +find: . (or whatever) ​
 +
 +replace: ^p
 +
  ​====== Search cells for specific text in cells and note it  ======  ​====== Search cells for specific text in cells and note it  ======
  
Line 76: Line 82:
  
 Click Data > Remove Duplicates, and then Under Columns, check or uncheck the columns where you want to remove the duplicates. Click Data > Remove Duplicates, and then Under Columns, check or uncheck the columns where you want to remove the duplicates.
 +
 +
 +{{:​removeduplicates.png?​500|}}
 +
  
  
  
excel.1570720015.txt.gz ยท Last modified: 2019/10/10 10:06 by zeppo