Thanks, it worked!
In the same column i also had some numbers with no symbol. I wanted the
number removed leaving a blank cell. Instead it has left the last number in
the row eg:

456236 left 6

How can i change this?

Thanks
--
Susan


"Gary''s Student" wrote:

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