View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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