I have a spreadsheet that needs to reference data for some of its functions
which is held in another spreadsheet on a shared server which is leading to
very long functions eg:

=IF(K$2='http://transfreespace.mycompany.co.uk/sites/ABC/2008 ABC Rollout
Schedule/[Latest Rollout Schedule - 2008.05.20 (Version 15).xls]Master
Schedule'!$AE6,"PMH",IF(K$2='http://transfreespace.mycompany.co.uk/sites/ABC/2008
ABC Rollout Schedule/[Latest Rollout Schedule - 2008.05.20 (Version
15).xls]Master
Schedule'!$AJ6,"LDV",IF(K$2='http://transfreespace.mycompany.co.uk/sites/ABC/2008
ABC Rollout Schedule/[Latest Rollout Schedule - 2008.05.20 (Version
15).xls]Master
Schedule'!$AP6,"SIM",IF(K$2='http://transfreespace.mycompany.co.uk/sites/ABC/2008
ABC Rollout Schedule/[Latest Rollout Schedule - 2008.05.20 (Version
15).xls]Master Schedule'!$AX6,"HOM",""))))

Is there some way I can 'define' something short to be egual to the bit -
'http://transfreespace.mycompany.co.uk/sites/ABC/2008 ABC Rollout
Schedule/[Latest Rollout Schedule - 2008.05.20 (Version 15)' and then
replace that in my formulas to make them easier to manage & read?

Thanks