LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John Michl
 
Posts: n/a
Default Function to add multiple "."s with a cell?

I wondered the same thing when I first posted but the original poster
asked specifically for an 8 character solution.

I don't know much about IP address standards but I believe that some
have two characters instead of one in those rightmost sections. If
there is a different number of characters or if the pattern is
different than the original poster suggested, I would think that you'd
be able to determine by your companies IP naming standards how to
modify the format or the parsing formula.

It begs the question is 123.123.1.1 the same as 123.123.01.01? If so,
I'd think you want to always use the leading zeros so that the formula
is consistent. On the otherhand, CDiddy may have had a one time need
and may not be concerned about future uses or IPs that look different
than the first example.

- John
www.JohnMichl.com

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help: I need a function for finding next cell vertically with value tobriant Excel Worksheet Functions 1 July 12th 05 08:39 PM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
Hyperlinks using R[1]C[1] and offset function in its cell referenc Elijah-Dadda Excel Worksheet Functions 0 March 5th 05 03:31 AM
Hiding a function value in a cell until function used Paul Smithson Excel Worksheet Functions 1 February 25th 05 06:19 PM
Function making cell really "empty" Arvi Laanemets Excel Worksheet Functions 2 January 31st 05 05:23 PM


All times are GMT +1. The time now is 04:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"