=LEFT(A2,1) & MID(A2,3,1) & MID(A2,4,1)

HTH,
--
George Nicholson

Remove 'Junk' from return address.


"lynn" wrote in message
...
I have list of numbers (approx 350) that is five digits long. Is it
possible
to use a formula to extract the 1st, 3rd and 4th digits from these numbers
and make another list. (ie. 12345 becomes 134, there are '0's starting
and
ending some of the numbers)