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.

What is Amazon Go and will it come to the UK? The store without checkouts or queues

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

Hands-on with the Star Wars fighting drones you can fly yourself

15 macOS Sierra tips | How to use macOS Sierra: Secret tricks and best new features in Apple's new…