Use DataText to Columns to split the numbers. You can specify the split
point as fixed points, each digit in your case.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"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)
|