Combining Left, Right and Mid

[Tplus9]

I have a column of numbers 8 digits long (text - to display leading zeros). I need to extract digits 2 and 5-8 and place in another column (e.g., 01234567 convert to 14567) or convert the numbers in the existing column. How do I format or combine Left, Right and Mid commands (or is there a different formula I should use)?

 

[Rick Rothstein]

Here are two different formulas that will each return the value you want...

=REPLACE(A1,1,4,MID(A1,2,1))

=MID(A1,2,1)&RIGHT(A1,4)

 

[Joe4]

Welcome to the Board!

Try (for an entry in cell A1):
=MID(A1,2,1) & MID(A1,5,4)

 

[TLWorth]

Thanks. Exactly what I needed.