| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
12 digit code sorting
The MID function returns a string/text result. The -- converts
the text result to a number. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "John Michl" wrote in message oups.com... Chip - what do the two dashes mean before the MID function. I've seen this in some SUMPRODUCT formulas but don't understand the significance. Thanks - John Michl |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| nine digit zip code won't print in mail merge | Excel Discussion (Misc queries) | |||
| Change case...help please | Excel Worksheet Functions | |||
| Macro for changing text to Proper Case | Excel Worksheet Functions | |||
| Using other workbooks.. | Excel Worksheet Functions | |||
| Make Change Case in Excel a format rather than formula | Excel Worksheet Functions | |||
Threaded Mode
