Search
soft hyphens
- Sean O'Shea
- 4 minutes ago
- 1 min read
Soft hyphens are a devilish little problem that can come up when you're parsing out data in Excel.
They are displayed as hyphens at the end of a cell, but don't show up in the formula bar.
If you click inside the cell, the hyphen disappears. Deleting doesn't get rid of it.
These invisible characters are used to mark hyphenation in connection with a line break for a word.
Soft hyphens can be entered with the alt code 0173. Simply enter this code in Find and Replace in Excel and replace it with a blank to remove it from your worksheet.
