Once we are there, we can push ourselves a little bit further with sorting. Thus, I recommend ignoring them as soon as you encounter them. These don’t really cause any harm, but they are bothersome to see. You may still get some warning messages on the cells from time to time. This will make things easier, particularly if you do that before writing the IP addresses in it. We will see a trick to help you sort multiple IP addresses.įirst, format the column where you want to put the IP addresses as text.
However, there are additional things you can do to ensure nothing breaks. Way to go when it comes to Excel and IP addresses is to write them as they are. Of course, your command prompt (or any other technical software), will only understand the IP address with the dots, so we need to find a different solution. Copy and paste eliminates the human error. You may want to have an IP address that you can copy in the prompt and ping, as Not so good when you have to write some more operative documents. In fact, you can see the IPĪddress almost immediately, once you understand the mechanism. This solution canīe good if you are writing an inventory of devices. This way, it is a valid digit, but you know you have three numbers for the first octet, three for the second, three for the third, and three for the fourth.īe so happy with that that it will never – ever – complain. Instead, we pad each octet with one or two zero. Since Excel do not like the dots, we simply never write them. Now that we know the problem, we can apply an easy solution that may be good for most cases. The dots are an issue for that, so it simply removes them. To help you, it wants to better process the number so that you can reference it later in formulas. It is a valid IP address, but it looks like 10 billion 100 million 240 thousand 112. It looks like you are writing some numbers in the order of the billions, using dots as separators for the thousands. Excel does not like IP addresses because they almost look like numbers. Excel IP Addresses The source of the problemīefore we can tackle this challenge, we need to know our enemy (Excel in this case). No extensions, no add-ons, no VBA – just plain old Excel. In this post, I show you one good way to manage IP addresses in Excel. Often times, Excel will simply break them and make your entire spreadsheet worthless. However, Excel and IP addresses do not seem to go along quite well.
And, if you are a network engineer, you will need to put IP addresses in Excel. No matter how technical you are, once in a while you have to work with Excel.
0 kommentar(er)
