in excel if i have a string of numbers example 12333222 and

in excel if i have a string of numbers example 12333222 and i want to only pull out the secound number out of the string using a formula for a large list which in this case the number would be a 2 how do i do this

Solution

To get the 2nd digit in a number we can do that in this way,

A1= 123456

A2=LEFT(RIGHT(A1, LEN(A1) -1), 1)

This works well even if we enter the number as string