B
Big Krackers
Hello,
I'm pretty new to Excel and database applications in general so forgive me
for any wording or vocabulary that I might lack.
I have a list of ip addresses, about 200 rows, in one column. The addresses
are separated into four octets (xx.xx.xx.xx) and I need to edit the last
octet in every row to zero so that it looks like xx.xx.xx.0
What I did was use the text to columns action to isolate the last octet into
it's own column so I could zero it out but then of course I couldn't figure
out how to merge everything back together again. (I figured out how to merge
on the cell level with multiple columns but I couldn't figure out how to get
the formula to work all the way down the list) So, what I think would be
simpler is to just learn how to edit the ip address in the original column
without using text to columns.
So for example:
Before: After:
A A
129.16.12.200 129.16.12.0
And so on all the way down the column. Note, the ip addresses are all
different.
Thanks,
BK
I'm pretty new to Excel and database applications in general so forgive me
for any wording or vocabulary that I might lack.
I have a list of ip addresses, about 200 rows, in one column. The addresses
are separated into four octets (xx.xx.xx.xx) and I need to edit the last
octet in every row to zero so that it looks like xx.xx.xx.0
What I did was use the text to columns action to isolate the last octet into
it's own column so I could zero it out but then of course I couldn't figure
out how to merge everything back together again. (I figured out how to merge
on the cell level with multiple columns but I couldn't figure out how to get
the formula to work all the way down the list) So, what I think would be
simpler is to just learn how to edit the ip address in the original column
without using text to columns.
So for example:
Before: After:
A A
129.16.12.200 129.16.12.0
And so on all the way down the column. Note, the ip addresses are all
different.
Thanks,
BK