View Single Post
  #4   Report Post  
momtoaj
 
Posts: n/a
Default

This formula will remove the first character regardless
of what it is, so be careful not to apply it to cell's
that don't have the < in front.

Assuming the first cell is A2, in cell B2 type:
=RIGHT(A2,LEN(A2)-1)
This removes the 1st character regardless of what it is.
Then you could copy & paste special over the original
entry.

Hope that helps!

-----Original Message-----
in Excel 2002, I have a column of data that includes

a "<" symbol, followed
by numbers. I want to get rid of the "<", and keep the

number in that cell.
The numbers vary throughout the column. any help?
.