excel spreadsheets linking between spreadsheets

  Newuser3477 15:17 07 Oct 2003
Locked

When linking cells between 2 spreadsheets I want to drop a suufix letter, that is I want 200p in the first spreadsheet to appear as 200 only in the linked cell in the second spreadsheet.I have tried all sorts of paste specials and format changes in the second spread sheet without sucess.Does anyone know how to do this?
Thanks
peter

  VoG II 15:26 07 Oct 2003

=LEFT(B5,FIND("p",B5)-1)

Obviously, modify to refer to the other workbook.

  Newuser3477 19:20 09 Oct 2003

Works a treat thanks VoG

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Intel Coffee Lake release date and specifications

12 Amazing British Craft Beer Label Designs

watchOS 4 review

Les meilleurs navigateurs internet 2017