I'm just getting into the data collection part of a project, and have a lump of 2,600 data values to analyse. It's not difficult, but I need to truncate the numbers, so that they only show the first digit.

i.e. I want the entry '76012' to show '7', '3145' to show '3'. and so on and so forth...

I need to do this so that I can use the COUNTIF formula on the data range to count to number of leading 1s, 2s, 3s, etc. to explore Benford's Law, and it's escaping me so far.

Any help would be excellent!

You need to use the Left function.

You're a star.
Thank you very much.

Wouldn't it be easier to do a pivot instead of using CountIf?