I have a large spreadsheet that in column 1 has,for example, the following information
Total Color
Total Red
Red
Pink
Orange
Total Blue
Light Blue
Navy
I want to count the number of leading empty spaces in order to format the sheet.
For example;
Total Color has 0 spaces
Total Blue and Total Red have 1 space
The rest, 2 leading spaces
I would like to create a count of those leading spaces and then I will format each differently. Keep in mind that the colors have nothing to do with the formats, these are just an example of the lists I may have.
Thanks
Total Color
Total Red
Red
Pink
Orange
Total Blue
Light Blue
Navy
I want to count the number of leading empty spaces in order to format the sheet.
For example;
Total Color has 0 spaces
Total Blue and Total Red have 1 space
The rest, 2 leading spaces
I would like to create a count of those leading spaces and then I will format each differently. Keep in mind that the colors have nothing to do with the formats, these are just an example of the lists I may have.
Thanks