| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing Empty Rows and selecting Specific Rows
I have a list of email addresses in one single column. This list is large so I need some way of shortcutting what I need t do. This entire column of email addresses is separated by 2 empty row between each email address. 1) Instead of clicking on each one and deleting them one by one, i there a quicker method to delete all empty rows? 2) The list of email addresses is imported. All the emaill addresses have a space in front of them. For example " Do you see the extra space in front of the emai address? How do I remove that single space with some sort of shortcut for th entire column? Appreciate the help, J -- Jethea ----------------------------------------------------------------------- Jetheat's Profile: http://www.excelforum.com/member.php...fo&userid=1007 View this thread: http://www.excelforum.com/showthread.php?threadid=39511 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting only specific rows for a Sort | Excel Discussion (Misc queries) | |||
| removing specific rows in a worksheet | Excel Discussion (Misc queries) | |||
| Macro for removing specific rows and columns, freezing panes..? | Excel Worksheet Functions | |||
| selecting specific rows with a algorithym!? | Excel Worksheet Functions | |||
| Removing Empty Rows from Worksheets | Excel Discussion (Misc queries) | |||
![Jetheat[_8_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
