Didnt mean to type question in twice!
I typed that formula into a blank cell but it wouldnt work, came up with a
box saying that the formulation contained and error, i copied it exactly.

Thanks
--
Susan


"Gary''s Student" wrote:

=IF(ISNUMBER(-RIGHT(A1,1)),"",RIGHT(A1,1))
This converts a trailing digit into a blank.

Is this answer good enough??
--
Gary''s Student - gsnu200791


"Sue" wrote:

Thanks, that worked but some cells only had a number and i wanted it to be
left blank but it has remained the last number that was in the cell, eg:

456896 now left with 6

Any ideas?
--
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