Hello Everyone,

I have a project to write SNORT IDS Rules. The end result is to provide the DNS syntax for any given domain name.

Example:

www.excelforum.com would be represented as |3|www|10|excelforum|3|com



1. A common delimeter is the same, a period "." in this case
2. Because any domain name is different, the number of characters of each area are separated by the period "."

I tried to use FIND, REPLACE, MID, CONCATENATE but I am lost. I can't seem to figure out how to make this work efficiently once I would provide the domain name in once cell and have my desired DNS result provided on another cell.

How can I approach this efficiently and effectively?

Thank you