Can someone explain this formula in laymans terms

[stroffso]

I was given a large sheet and this formula seems to be causing an issue,

thanks in advance


=IFERROR(REPLACE(N8,FIND("'X'",N8,1),3,F8),N8)

 

[Marcelo Branco]

The formula says:
If 'X' is found in N8 then
return the value in N8 replacing these 3 caracteres by the text in F8.
Else
return the value in N8 with no changes
End If

Remark: the FIND function is case sensitive, so if the text in N8 contains 'x' (lower case) nothing changes.

M.

 

[stroffso]

Thanks so much thats great

The formula says:
If 'X' is found in N8 then
return the value in N8 replacing these 3 caracteres by the text in F8.
Else
return the value in N8 with no changes
End If

Remark: the FIND function is case sensitive, so if the text in N8 contains 'x' (lower case) nothing changes.

M.

 

[Marcelo Branco]

You are welcome. Thanks for the feedback.

M.