Searching a cell value for a Character

If you were looking for a VBA solution, you should've posted in the Programming forum...

We'll see if someone with VBA skills will join and add a suggestion.

Good afternoon dsexpress

For clarification - are you wanting to extract each number from the string in a cell?
What are you hoping to compare them to?

DominicB

Hi dsexpress

This code will do what you want, but in the absence of guidance from yourself, it will take its value from A1, and subtract from that the sum of values in range B1:B10, and then display the result in a MsgBox :

Sub test()
Dim Ex As Long, Tot As Long
Ex = Left(Range("A1").Value, InStr(1, Range("A1").Value, "/") - 1)
Tot = Application.WorksheetFunction.Sum(Range("B1:B10"))
MsgBox Ex - Tot
End Sub

HTH

DominicB

Hi dsexpress

Originally Posted by dsexpress

I just need to test the cell for contents of "/". I am going to assume the find function?

I'm not sure what you mean. Do you want to test first whether the cell contains a "/"? If so what do you want to do if a "/" isn't found?

If I've got it totally wrong and am barking up the wrong tree, explain to me exactly what you mean.

DominicB