Parse 5th Digit

[Saxman]

In a series of numbers contained within one cell such as:-

287351

How do I extract 5 to a new column?

TIA

 

[Saxman]

If the number is in cell A1, then in column B1 you enter =1*MID(A1,5,1)
(You multiply by 1 to convert the result from a string to a number. If you just want the string value, omit 1* from the formula.)

Of course, you'll get an error if the number doesn't have a 5th digit.

Howard

That works fine. Thank you very much Howard.