Mid function should do the job
sk

dalymjl wrote:
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?


--
dalymjl