Home |
Search |
Today's Posts |
#1
|
|||
|
|||
is there a formula out there?
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) |
#2
|
|||
|
|||
=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) |
#3
|
|||
|
|||
=LEFT(A2,1) & MID(A2,3,2)
Tim C "George Nicholson" wrote: =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) |
#4
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |