| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
delete data from column
Hello, I have a lot of emails in my excel columns, from A 1 to A 100. 100
emails. I want to get rid of, delete this < from my emails. example that i have now i want to be like this. there is a way to remove these fast without going one by one?? thanks reply or comment. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
delete data from column
Edit Replace < with nothing then Replace with nothing.
-- Regards Dave Hawley www.ozgrid.com "Christian" wrote in message ... Hello, I have a lot of emails in my excel columns, from A 1 to A 100. 100 emails. I want to get rid of, delete this < from my emails. example that i have now i want to be like this. there is a way to remove these fast without going one by one?? thanks reply or comment. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
delete data from column
To add on; make sure 'Match entire cell contents' is unchecked..
-- Jacob (MVP - Excel) "ozgrid.com" wrote: Edit Replace < with nothing then Replace with nothing. -- Regards Dave Hawley www.ozgrid.com "Christian" wrote in message ... Hello, I have a lot of emails in my excel columns, from A 1 to A 100. 100 emails. I want to get rid of, delete this < from my emails. example that i have now i want to be like this. there is a way to remove these fast without going one by one?? thanks reply or comment. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How 2 lock row and column delete/add but allow data entry? | Excel Discussion (Misc queries) | |||
| Copy column header to next column, delete & delete every nth colum | New Users to Excel | |||
| Delete row where there is duplicate data in Column E | New Users to Excel | |||
| How do I delete data in a column from a certain point on? | Excel Worksheet Functions | |||
| In a column of text data, how do I delete random cells that have . | Excel Discussion (Misc queries) | |||
Hybrid Mode
