How do I find/replace a "<" symbol?

D

Derek Z

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

Jason Morin

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

Find What: <
Replace With: <leave empty>

3. Press "Replace All".

HTH
Jason
Atlanta, GA
 
P

Pank Mehta

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

momtoaj

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!
 
Top