View Single Post
  #1   Report Post  
Mike_sharp
 
Posts: n/a
Default shortening a forumula

im using excel 2003

i would like to reduce the size of the following formula as t is too big to
use..

=€˜\\stock\uk\Break Fix\KPI Reports\[ Break Fix KPi Report 2005
Swindon.xls]WC 180405'!B3+\\stock\uk\Break Fix\KPI Reports\[ Break Fix KPi
Report 2005 Hemel.xls]WC 180405'!B3+\\stock\uk\Break Fix\KPI Reports\[ Break
Fix KPi Report 2005 Milton Keynes.xls]WC 180405'!B3+\\stock\uk\Break Fix\KPI
Reports\[ Break Fix KPi Report 2005 Pangbourne.xls]WC
180405'!B3+\\stock\uk\Break Fix\KPI Reports\[ Break Fix KPi Report 2005
Llandarcy.xls]WC 180405'!B3+\\stock\uk\Break Fix\KPI Reports\[ Break Fix KPi
Report 2005 Stanlow.xls]WC 180405'!B3 +\\stock\uk\Break Fix\KPI Reports\[
Break Fix KPi Report 2005 Avonmouth.xls]WC 180405'!B3+\\stock\uk\Break
Fix\KPI Reports\[ Break Fix KPi Report 2005 Sunbury.xls]WC
180405'!B3+\\stock\uk\Break Fix\KPI Reports\[ Break Fix KPi Report 2005
Aberdeen.xls]WC 180405'!B3+\\stock\uk\Break Fix\KPI Reports\[ Break Fix KPi
Report 2005 Sullom Voe.xls]WC 180405'!B3+\\stock\uk\Break Fix\KPI Reports\[
Break Fix KPi Report 2005 Teeside.xls]WC 180405'!B3+\\stock\uk\Break Fix\KPI
Reports\[ Break Fix KPi Report 2005 Dimlington.xls]WC
180405'!B3+\\stock\uk\Break Fix\KPI Reports\[ Break Fix KPi Report 2005
Wytch Farm.xls]WC 180405'!B3+\\stock\uk\Break Fix\KPI Reports\[ Break Fix
KPi Report 2005 Coryton.xls]WC 180405'!B3+\\stock\uk\Break Fix\KPI Reports\[
Break Fix KPi Report 2005 St James.xls]WC 180405'!B3+\\stock\uk\Break
Fix\KPI Reports\[ Break Fix KPi Report 2005 Britannic House.xls]WC 180405'!B3

the path is the same for each file...

thanks