<div>
Do you a ready excel file?<br />
<br />
Do you know the exact cell that the IP address resides in?
</div>


Do you a ready excel file?

Do you know the exact cell that the IP address resides in?

sshot-440.png

<div>
Or if you have IP addresses that start 10.7.177. and then 3 other numbers which you want to replace with 128 you can use Find and Repalce feature. Press Ctrl + H to start Find/Replace window.<br />
<br />
In Find input box enter: &nbsp;10.7.177.*<br />
In Replace box enter: 10.7.177.128<br />
<br />
Thanks<br />
Rob
</div>


Or if you have IP addresses that start 10.7.177. and then 3 other numbers which you want to replace with 128 you can use Find and Repalce feature. Press Ctrl + H to start Find/Replace window.

In Find input box enter:  10.7.177.*
In Replace box enter: 10.7.177.128

Thanks
Rob

<div>
Bill Prew suggested solution answers the question in a good and simple way
</div>


Bill Prew suggested solution answers the question in a good and simple way

<div>
<div class="content wysiwyg-content">
Need to add .128 &nbsp;on IP 10.7.177.* in excel
</div>
</div>


Need to add .128  on IP 10.7.177.* in excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.