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?

1. Select the range.
2. Press Ctrl+H.

Find What: <
Replace With: <leave empty

3. Press "Replace All".

HTH
Jason
Atlanta, GA

-----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?
.

Derek,

Firstly highlight the column that contains the data you want replace.

Secondly, depress the CTRL and H key. A popup will appear. Fill in the
appropriate field and ensure that the Search parameter says Colums (drop
down list) and then select replace all.

I would recommend that you save your sheet first to ensure that if it
doesn't work you can go back.

HTH.

"Derek Z" wrote:

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?

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?
.