| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
2 DIGITS OUT OF 4
=Mid(cell-reference,2,2)
the first '2' tells Excell where to start, the second '2' tells excel how many characters to extract. the MID function extracts data from the middle of a string of characters, similar to LEFT and RIGHT --------------= Posted using GrabIt =---------------- ------= Binary Usenet downloading made easy =--------- -= Get GrabIt for free from http://www.shemes.com/ =- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort by last 2 digits | Excel Worksheet Functions | |||
| 15 digits??? | Excel Discussion (Misc queries) | |||
| Least number of digits in Y-axis labels | Charts and Charting in Excel | |||
| How do I format cells to a specific number of digits? | Excel Discussion (Misc queries) | |||
| Using a IF formula, I would like to drop the 2 digits in front of. | Excel Discussion (Misc queries) | |||
Linear Mode
