Solved Calculate dots to determine the level

July 26, 2012 at 04:00:12
Specs: Windows XP, 1.00 GB
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 the level is 3 ...... etc

please I need this support as soon as possibele

See More: Calculate dots to determine the level

Report •

July 26, 2012 at 06:26:09
✔ Best Answer

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.

Report •

July 27, 2012 at 00:53:39
Thank you so much
it works perfecltly as I want
you are the best

Report •

Related Solutions

Ask Question