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.

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.

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.

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.

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.