Assume a column with some IP addresses. Each cell has 4 portions separate by a dot. The number of digits in each portion can either be 2 or 3. The following tasks need to be performed on this dataset:
1. Drop the last portion of the string
2. Flip the string
3. Add the following text to the flipped string – “in-addr.arpa” (without double quotes)
The base data and expected solution is shown below
While this can be resolved by writing formulas, I have shown a Power Query solution in this workbook.
You may also watch a short video of my solution here
Flip a string with conditions
{ 2 Comments }