If the data is in column A, then

=RIGHT(A1,1) and copy down
--
Gary''s Student - gsnu200791


"Sue" wrote:

I have columns with numbers and symbols in. They look like this:

456456*
521369*
789456!

I have highlighted the column and i want to remove any numbers in the cells
but keep the symbol in the cell.
I tried shift and F but i couldnt get it to do this for any number that
appears in the cell, i found i had to type in the specific no then it would
work.
This is too time consuming, I have alot of columns!

Any help will be appriciated.

Thanks,

--
Susan