Formula confusion

S

Steve Abrams

Hi everyone,

I'm trying to convert another IP address using a formula. I'm working
with 10.101.78.1 as the initial address and want to add a column that
will convert it to 10.0.101.77.

The format is A. 10.101.78.1, B. 10.0.101.78, C. 10.0.101.77

I can successfully get the address to B. 10.0.101.78 using,

=CONCATENATE("10.0.",RIGHT(LEFT(A1,LEN(A1)-2),LEN(A1)-5)).

I have been unsuccessful in figuring out the last address using A as
the source for C. Is it possible to use A as the source for C or do I
need an intermediary step? I want to avoid using B as the source for
the formula.

Any suggestions are appreciated.

Steve
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function to Combine Names and Middle Initital In Various Formats 3
Converting from Decimal to Base-36 in Excel Formula 3
Prompt For Replace in Selection And More... 0
Copying formulas across columns 2
Problem using IF statement with dates as part of the formula 4
Data Validation - Custom question (multiple conditions) 8
Formula I can't figure out 2
Formula than understands midnight? 26

Top