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.

Samsung Galaxy S8 review

1995-2015: How technology has changed the world in 20 years

This 2D animation about monsters is illustrated in a Van Gogh painterly style

How to get WWDC 2017 tickets