G
gary
A1 thru A31 contains a total of 214 characters.
A lot of the cells have a custom number formats (like 00000000000 or
00000 or 0000000).
A32 contains =A1&B1&C1 thru A31
=len(A32) is 97 (not 214).
Is this discrepancy due to the custom number formats?
How do I get the result of =len(A32) to be 214?
A lot of the cells have a custom number formats (like 00000000000 or
00000 or 0000000).
A32 contains =A1&B1&C1 thru A31
=len(A32) is 97 (not 214).
Is this discrepancy due to the custom number formats?
How do I get the result of =len(A32) to be 214?