Help with this Formula

[firstWeMeet]

I am thinking how it will works.
Sheet1 C5 = 7922174
Sheet2 C5 = 2365422
then Sheet3 C5 = should look like this 7922174 / 2365422
Thanks for upcoming help.

 

[VoG]

Like this?

=Sheet1!C5&"/"&Sheet2!C5

 

[sykes]

=Sheet1!C5 & " / " & Sheet2!C5

 

[sykes]

Sorry Peter, you beet me to it!
Also, I didn't know if the OP wanted space characters - as in their example.

 

[firstWeMeet]

Thanks both of you. its working.

 

[firstWeMeet]

Just a little confusing outcome with this
=IF(Sheet1!C5&Sheet2!C5 ="","",Sheet1!C5 & " / " & Sheet2!C5 )
can you help me again with this because the outcome of this formula was this:
Sheet1C5=7922174
Sheet2C5=0
Then Sheet3C5=7922174 /
I want the / to be not included

 

[VoG]

Try

=IF(AND(Sheet1!C5="",Sheet2!C5=""),"",IF(Sheet1!C5="",Sheet2!C5,IF(Sheet2!C5="",Sheet1!C5,Sheet1!C5&"/"&Sheet2!C5)))