Removing digits from front and back of number in a cell

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

I have a column of numbers that I need to delete the
first 5 digits of the number and the last 2 digits of the
number. Can this be done in Excel? If so, how?

Any help would be appreciated.

Thank you,
Scott
 
Hi Scott,

Assuming your number is in cell A1

=LEFT(RIGHT(A1,LEN(A1)-5),LEN(A1)-5-2)

Or slightly simplified,

=LEFT(RIGHT(A1,LEN(A1)-5),LEN(A1)-7)

Hope that helps.

Regards,
Kevin
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How add a digit to front of number in each cell in excexl column 1
Excel 2003: Cell rounds 16 digit numbers- How to advoid rounding? 1
Need 7 digit number with differnt number of leading zeros 10
Loop 1
Working with numbers in Excel-Specify # of digits 6
Maximum amount of numbers in one Cell 2
How to Combine two cells (numbers) but not add 7
Extracting 7 digit number from alphanumeric string 10

Back
Top