A Question About Mac Excel Use...

[Guza]

I’m looking for a way to find the full character count of an Excel document (including multiple sheets) to determine differences in many Excels that I have. I’ve seen on YouTube the formulas to count per cell or per column or per sheet, but does anyone know of a way to show the total character count for the full document? Thank you in advance.

 

[casperes1996]

I’m looking for a way to find the full character count of an Excel document (including multiple sheets) to determine differences in many Excels that I have. I’ve seen on YouTube the formulas to count per cell or per column or per sheet, but does anyone know of a way to show the total character count for the full document? Thank you in advance.

My recommendation is just to add up the characters from all the sheets.

 

[Guza]

ooof, too many sheets in too many excels, is there any other less laborious way of doing it?

 

[casperes1996]

ooof, too many sheets in too many excels, is there any other less laborious way of doing it?

Not that I know of, for getting the exact character count.

Maybe, depending on how Excel stores the data, you could use the wc command (word count)