excel
Differences
This shows you the differences between two versions of the page.
| 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
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
