Changing Titles by a formula

[Heather]

From cell A1:A10 I have standard titles that are linked to
another sheet. I only need to change the office and date
per each title. Is thier a way to do that making the
office and date a formula in another cell?

example of title

ABC Comp, Office 38L Sales as of 6/07/2004

I need to only keep changeing the 38L and date.

Any suggestions----Thanks

 

[Guest]

Say Office # is in Column 'C'

in cell A1:
="ABC Comp, Office "&C1&" Sales as of "&Today()


----- Heather wrote: -----

From cell A1:A10 I have standard titles that are linked to
another sheet. I only need to change the office and date
per each title. Is thier a way to do that making the
office and date a formula in another cell?

example of title

ABC Comp, Office 38L Sales as of 6/07/2004

I need to only keep changeing the 38L and date.

Any suggestions----Thanks

 

[Heather]

They date does not work it formats as text, not a date

 

[Frank Kabel]

Hi
try
="ABC Comp, Office "&C1&" Sales as of "&TEXT(Today(),"MM/DD/YYYY")