Thread
:
Excel 97 Find and Replace
View Single Post
#
2
Posted to microsoft.public.excel.misc
Dave Peterson
external usenet poster
Posts: 35,218
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
Reply With Quote
Dave Peterson
View Public Profile
Find all posts by Dave Peterson