excel spreadsheets linking between spreadsheets

  Newuser3477 15:17 07 Oct 03
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 03

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

Obviously, modify to refer to the other workbook.

  Newuser3477 19:20 09 Oct 03

Works a treat thanks VoG

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

Surface Pro 5 News - release date, UK price, features, specs

Microsoft Surface Studio hands-on review: the iMac killer is here

Best Mac antivirus 2017