| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IP Trimming
Hello,
Does anyone have a good formula to trim an IP Address down to its first three octets? For example, Starting with "192.168.1.105" and go to "192.168.1." Any help would be much appreciated. Thanks, Josh |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IP Trimming
Try the following formula, where your IP address is in A1.
=LEFT(A1,FIND(".",A1,FIND(".",A1,FIND(".",A1,1)+1) +1)-1) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Josh" wrote in message oups.com... Hello, Does anyone have a good formula to trim an IP Address down to its first three octets? For example, Starting with "192.168.1.105" and go to "192.168.1." Any help would be much appreciated. Thanks, Josh |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trimming a cell down to 256 Characters | Excel Discussion (Misc queries) | |||
| Grid column display text trimming | Excel Discussion (Misc queries) | |||
| trimming blank cells | Excel Worksheet Functions | |||
| Text to Columns in excel for delimited files - allow trimming opt. | New Users to Excel | |||
| Trimming Spreadsheet. How to get excel to recognize only used spa | Excel Discussion (Misc queries) | |||
Linear Mode
