if statement help

[ariel20029]

Hi,
Can you help me with an if statement. Sometimes an enduser name has a / in the name we need to change the / to an _

For example
John Doe/ Jane Doe and I need it to be John Doe_Jane Doe.
I really do not have any idea how to write this if statement.
thanks,

Sharon

 

[Tetra201]

Assuming your text string "John Doe/ Jane Doe" is in cell A1, see if this works for you:

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TRIM(A1),"/","_"),"_ ","_")," _","_")

 

[ariel20029]

Thank you so much, that worked perfectly.
Sharon

 

[Tetra201]

You are welcome.