Find and replace only the whole number in Excel

[rufuswrong]

hello

I am using the find and replace (Cntrl F) in a worksheet but am being frustrated by being unable to get excel to only replace the exact number not the derivatives.

EG I wish to search for all HS10 and replace with S70 but in addition to HS10 excel wants to replce anything starting with HS10 like HS101 or HS100345. How can I get it to only selec HS10 and nothing except HS 1?

Thanks a lot

 

[Trevor G]

Welcome to the forum, try something like this via code

Sub replace1()
Dim rep As String
Dim newrep As String
rep = "HS10"
newrep = "S70"
For Each cell In Range("A1:IV600")
If cell.Value = rep Then
cell.Value = newrep
End If
Next
End Sub