I am wondering whether the following is possible using a simple function in Excel? I have a column of class C IP ranges like below:
145.45.67
145.45.68
145.45.69
145.45.70
145.45.71
145.45.75
145.45.76
145.45.77
145.46.11
145.46.12
145.46.13
I need them in range format like...
Been trying to find a solution to this one all morning. Have a column of IP's in Excel (for Mac if it makes any difference) and I wanted to shorten them all down to C class level.
I.e
255.255.255.255
becomes
255.255.255
I have played with lots of built in functions but because the last...
If I have a column containing search keyphrases, is it possible using a VB macro to output all possible inverted 2 keyword phrases if they do not already exist?
For example:
keywork 1 keyword 2
Would be converted to keyword 2 keyword 1 if the inverted phrase did not exist already in the...
Hi all,
We are running MS SBS 2003, ISA enabled. All clients on Win XP Pro.
On one of the client machines we have apache installed, which over the past few weeks has been visible but intermittently via http://clientname/ from many of the other clients on the network.
Any ideas which may...
Hi all,
Got a Dell Poweredge running NT 4 Server - in this day and age what anti virus precautions do I need to take - is it the same as thinking about a home desktop?
Also what would you recommend software wise as NT 4 is not supported by many of the newer titles.
Thanks
Dan
Dan Morgan -...
Hi all,
After finally getting NT4 Server up and running on a Poweredge 2400 I am having a few problems getting clients to browse shares on the box.
Currently I only want to use it as a stand alone, while I find my feet and we have only about 5-7 computers.
I have setup shared directories on...
Hi all,
Anyway to validate the form of a column of email addresses in excel? It just needs to make sure there are not any spaces, illegal email characters and forms?
Many thanks,
Dan
Dan Morgan - www.ski-review.com
Hello Everyone,
I have had a fun couple of days wrestling with the problem, and I am now at a stage where I have to ask for help!
Let me say that until yesterday I had no experience whatsoever with this type of project - PC's I am fine with, servers area whole different ball game.
I am...
Hello,
I have an excel database which was exported from a query in business. Line breaks are present but in addition to windows line breaks which apart from the obvious are invisible, those square block symbols are also present. Normally the windows line breaks are no problem and I wold...
Hello All,
I have a question regarding caching with javascript.
Traditionally, banner dispayed on webpages are done so by using a timestamp or random number either clientside using javascript or serverside. This ensures a revisit to a page forces a new banner to be called rather than using a...
Hey,
Anyway to use Sharepoint TS with FP 2002 to allow a web page to be translated to other languages on the fly.
Its an intranet so something like http://www.translate.com/?htpp://my_intranet.com doesnt work as the intranet is secure and not available to servers outside the LAN.
Tahnks,
Dan
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.