Parse 5th Digit

  • Thread starter Thread starter Saxman
  • Start date Start date
S

Saxman

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

287351

How do I extract 5 to a new column?

TIA
 
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
Click to expand...


That works fine. Thank you very much Howard.
 
Back
Top