Formula / Partial part of result to change as per sourced cell value

[DeepuTheGreat]

Hi Friends,

I am working on a project. I need partial part of the result derived from a formula, to keep changing based on the sourced cell value.
for e.g. A1 is the sourced cell. It has the value as "Team A".
In B1, the result should occur as "The Game is won by Team A".
Now, if the value of A1 changes to "Team B", B1 should also get changed to "The Game is won by Team B".

 

[Fluff]

Hi & welcome to MrExcel
How about
="the game is won by " & A1

 

[DeepuTheGreat]

Dear Sir

Thank you very much for welcoming me to MrExcel and for your feedback.

The formula suggested by you is working. Only thing how to add space in two words. Though I am leaving space inbetween two words and '&", they are appearing in continuous mode, making impression of one word only.

Pls advise.

 

[Fluff]

Can you post the formula you are using.
My solution will give a space before the value of A1

 

[DeepuTheGreat]

Dear Sir,

Thank you for your feedback.

I have written the formula as below:
=IF(TEAMA!C104>TEAMB!C104,TEAMA!B102 & "WIN BY" & TEAMA!C104-TEAMB!C104 & "RUN",0)

Result appears as : A1WIN BY1RUN

There is no space in between (a) A1 and WIN, (b) BY and 1, (c) 1 and RUN.

Pls advise.

 

[Fluff]

Just add spaces as needed like " WIN BY "

 

[DeepuTheGreat]

Great!! That's working.

Thank you very much for helping me out.

Bregards
Deepak

 

[Fluff]

Glad to help & thanks for the feedback