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

iPhone X review

How to find a font: Discover the name of a typeface with these apps

The best iPhone for 2017

Les meilleurs logiciels de montage vidéo gratuits (en 2017)