Selecting a digit from a code

Warren99 · #1 05-28-2016, 06:15 PM

BP76412008 is a code for a pile. The sixth digit is the depth of the pile. What function would I use to extract this number to compare it with the depth recommended by the engineer.

macropod · #2 05-28-2016, 09:46 PM

Assuming BP76412008 is in A1, you could use a formula like:
=MID(A1,6,1)

Warren99 · #3 05-29-2016, 04:08 AM

Thank you for that.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
number field coming over with missed digit	sherrin	Mail Merge	1	04-20-2016 06:06 PM
Regex/wildcard search for dates with 2-digit and 4-digit years	Marrick13	Word VBA	2	01-29-2016 07:04 AM
A challenging digit by digit manipulation, rotate the digit in range of 0 to 9	laucn	Excel Programming	14	05-17-2015 12:12 PM
Import contact from EXCEL to Outlook (no zero in left side digit)	nmo111	Outlook	1	05-28-2010 11:00 AM
Dividing merge cell into ten equal rectangles for inputing Digit?	aligahk06	Excel	0	05-12-2010 06:56 AM