| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Funciton to subtract and add a digit to an IP address format?
Hello,
Is there an excel funciton I can use to subtract a digit and add a digit for an IP address format? For example: I have a known IP address of 172.24.137.149 in cell B2 and I would like to create a funtion in cell A2 to subtract 1 digit which would result in 172.24.137.148 and another function in cell C2 to add 1 digit which would result in 172.24.137.150. Thanks, Jaret |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I have a 38 digit # and I want to subtract 27 thru 32 from 33 thru | Excel Worksheet Functions | |||
| Format to Round to Tens Digit | Excel Discussion (Misc queries) | |||
| Format 2 digit year to 4 digit | Excel Discussion (Misc queries) | |||
| divide a total, subtract one then format as a percentage | Excel Worksheet Functions | |||
| How do i change the format of a 2 digit date | Setting up and Configuration of Excel | |||
Threaded Mode
