Hello , I got a problem in in office software and I hope from anybody to help me.

I export data from an application to excel sheets

the first column of the exported data ( Column A ) has some information but starts like 16.1 or 16.1.1 .... etc ,,, I need help to create an column on the right named be level and calculate the number of dots for example ,, 16.1.1 the level is 2 ,, or 16.1.3.4 the level is 3 ...... etcplease I need this support as soon as possibele

=LEN(A1)-LEN(SUBSTITUTE(A1,".","")) It works by calculating how long the string would be if the dots were removed and then subtracting that value from the length of the original string.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Thank you so much

it works perfecltly as I want

you are the best

Ask Your Question

Weekly Poll