ExcelBanter - Return first 'n' characters

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Return first 'n' characters (https://www.excelbanter.com/excel-worksheet-functions/35289-return-first-n-characters.html)

dalymjl

Return first 'n' characters

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?

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

dalymjl

Quote:

Originally Posted by 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?

Problem solved: =LEFT(A1,7)

All times are GMT +1. The time now is 08:33 PM.