how to exclude specific characters

[c_lansman]

I have a column of excel values that end with >,

ex

110010>
999>
505550>
ect....

I need to store these values in a variable to compare to another table on another page but i want to exclude the > at the end of the #'s. How would i go about doing this?

Thanks!

 

[PaddyD]

=substitute(a1,">","")

 

[VoG]

In code, something like

Sub test4()
Dim x As String
x = Left(Range("A1").Value, Len(Range("A1").Value) - 1)
MsgBox x
End Sub

Edit:

or

x = Replace(Range("A1").Value, ">", "")

 

[Scott Huish]

In code, perhaps:

Sub test()
Dim x As Long
x = Val(Range("A1"))
MsgBox x
End Sub