Excel: Effectively search and replace specific characters
Filed in Excel on Aug.16, 2007. Email This article to a Friend
Here is a list with numbers separated with a "-".
Problem: Remove "-" from list.

- Select all numbers to be converted.
- Go to "Home" tab.
- Left click with mouse on Find & Select.
- Select Replace (Ctrl + H)

- Type "-" in "Find what:" box.
- Type nothing in "Replace with:"

- Click "Replace All".
- The same list without "-".






