Is there a simple formula or function to count the number of characters and spaces in a cell
TIA
Mike K
OssieMac - 29 Aug 2007 00:34 GMT
Hi Mike,
=LEN(B2)
Regards,
OssieMac
> Is there a simple formula or function to count the number of characters and spaces in a cell
>
> TIA
>
> Mike K
Charles W Davis - 29 Aug 2007 00:40 GMT
Mike,
I create a new column. Then in the adjacent cell I place: =LEN(P737) where P=the Column and 737 is the row.
Is there a simple formula or function to count the number of characters and spaces in a cell
TIA
Mike K