Reference Cell with multiple words and put underscore in between

[telecomadmin12]

My content in a cell is one, two or three words, separated by space.
I want to reference the content in another cell, but put a underscore between the words, add the content from another cell and add some text.

This is what I have in my cells.
[pre] A B[/pre]
1 [box]Michaela[/box] [box] Meier[/box]

2 [box]Tom Rich[/box] [box]Muller[/box]

I want to have in a different cell:
[pre] F [/pre]

1 [box]Michaela_Meier.png[/box]

2 [box]Tom_Rich_Muller.png[/box]

What would be the formula for that?

 

[combo]

Assuming no other cases to include in output:
=SUBSTITUTE(A1," ","_")&"_"&B1&".png"

combo

 

[SkipVought]

I'd suggest using the SUBSTITUTE() function on both references, if you might have a Van Winkel, for instance.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[telecomadmin12]

Thank you both.
And Skip is right, I do have a Van Winkel, how did you know?

How would the formula look then, if I want to substitute all spaces with "_" in the second cell too?

 

[SkipVought]

How do I know? I don't give a RIP!

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[combo]

Instead of pure B1 in the second part of formula use SUBSTITUTE, as in first part, but with B1 as argument.

combo