Return first 'n' characters

D

dalymjl

I have a spreadsheet with a column containing a reference number which
consists of 7 digits followed by a letter (e.g. 1234567P). How do I get
Excel to write just the 7 digits to a new column?
 
Top