adding text to a linked cell

[melvin]

Hi folks,

I am trying to format a cell that reads text from another cell and als
adds additional text after it.

For example,

In cell A1 I have entered the text "Joe Blogg". In cell A10, I woul
like it to read as "Joe Blogg's Team" by entering " 's Team" somehow.
So, in the case of changing cell A1 from "Joe Blogg" to "Daffy Duck" i
automatically changes cell A10 to "Daffy Duck's Team".

Does anyone know of a way this can be done?

Many thanks for any assistance,

regard

 

[Frank Kabel]

Hi
if you use cell A1 and A2 with both of theses text values use the
following in A10:
=A1 & A2

 

[Andy B]

Hi

Try
=A1&"'s Team"

Andy.

 

[melvin]

Excellent!!! That has saved me a lot of manual input!

Many, many thank

 

[melvin]

Andy/Frank,

The suggestions work well, however I am also looking to change the tex
to upper case if possible.

E.g. in A1 "Joe Blogg", in A10 "JOE BLOGG'S TEAM".

Is there a seperate command that can be integrated into the above???

Thanks for your support guy

 

[Frank Kabel]

Hi
try
=UPPER(A1 & "s team")