You might need a macro for this:

Sub crln()
Set rr = Range("A1:A10")
For Each r In rr
If r.Value = 400 Then
r.Value = "James"
End If
Next
End Sub

--
Gary''s Student - gsnu200785


"Carolan" wrote:

Would like equation that says if A1 to A10 has 400 in it, the change 400 to
"James"
Could someone please help me.
--
Carolan