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) |
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 |