instead of
=if(a1 < "",1)

use
=if(a1 < "",len(a1))

this will give tthe number of characters (bytes) in each cell for text
characters.


" wrote:

Hi,

Does anyone know of a quick way of working out how much data a row
contains?

I was hoping to be able to make an estimate of how big a workbook
could get.

Thanks,
Mark