View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
 
Posts: 1,805
Default Editing in excel

Click anywhere on address column
Choose Edit|Delete and click on 'Entire Column' option and Click 'OK'

"Scott" wrote:

I have names and phone numbers in one colunm, addresses in another one. All I
want to do is keep the names and phone numbers how do I delete the rest?

--
Scott