Thursday, May 12, 2011

How to Take Out Hyphens From a Cell in Excel 2007


1. Select a blank cell next to the desired cell containing text (source cell).
2. Type '=substitute(' and then click the cell containing text (source cell).
3. Type a comma followed by a space and a hyphen between quotation marks. Type a comma and then press the 'Space' key. For example, the formula in the cell will now read '=substitute(A3, '-', '
4. Type the desired characters to replace the hyphen, enclosed in quotation marks, or simply type two quotation marks to remove the hyphens. Type ')' to complete the formula. For example, to remove hyphens and replace them with a period, the formula will read '=substitute(A3, '-', '.')' or to remove hyphens the formula will read '=substitute(A3, '-', '')' in the cell.
5. Press the 'Enter' key to complete the SUBSTITUTE formula.

Blogger news