ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Editing in excel (https://www.excelbanter.com/excel-discussion-misc-queries/207838-editing-excel.html)

scott

Editing in excel
 
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

Sheeloo[_3_]

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


ShaneDevenshire

Editing in excel
 
Hi,

Click the column letter at the top of the address column and press Del.

--
Thanks,
Shane Devenshire


"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



All times are GMT +1. The time now is 02:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com