I export data from an application to Excel sheets.
The first column of the exported data (Column A) has some information, but contains text like
16.1.1, etc. I need to create a column right next to it, containing the "level", which is calculated by the number of dots.
For example, for
16.1.1 the level is 2, or for
18.104.22.168 the level is 3.