Excel 97 Find and Replace
 

Have the following issue:

Column of telephone numbers are listed as follows:

### #######

Is there a way using find and replace to delete the space between the
first three digits and the last seven?

Any help would be appreciated

Excel 97 Find and Replace
 

Select the range to fix
Edit|replace
what: (space character)
with: (leave blank)
replace all



wrote:

Have the following issue:

Column of telephone numbers are listed as follows:

### #######

Is there a way using find and replace to delete the space between the
first three digits and the last seven?

Any help would be appreciated

--

Dave Peterson