| 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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
delete data from column
Micky,
It is unchecked by default; but it retains the last setting used... I didnt see a response from the OP for more than an hour; and hence thought to add this; didnt mean anything else... -- Jacob (MVP - Excel) "מיכאל (מיקי) אבידן" wrote: I don't want to sound like Dave Hawley attorney - but I'm sure he didn't find it necessary to mention that - because 'Match entire cell contents' is unchecked BY DEFAULT(!) Micky "Jacob Skaria" wrote: 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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
delete data from column
Jacob, good catch :)
-- Regards Dave Hawley www.ozgrid.com "Jacob Skaria" wrote in message ... Micky, It is unchecked by default; but it retains the last setting used... I didnt see a response from the OP for more than an hour; and hence thought to add this; didnt mean anything else... -- Jacob (MVP - Excel) "מיכאל (מיקי) אבידן" wrote: I don't want to sound like Dave Hawley attorney - but I'm sure he didn't find it necessary to mention that - because 'Match entire cell contents' is unchecked BY DEFAULT(!) Micky "Jacob Skaria" wrote: 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) | |||
Linear Mode
