Is there any way to count the characters in a cell?
I have to only have 12 in one and 30 in another.
HELP!!
christa
Is there any way to count the characters in a cell?
I have to only have 12 in one and 30 in another.
HELP!!
christa
The formula is
=LEN(A1)
Substitute your actual cell reference for A1. This returns the number
of characters in a string.
YES!!!! THANK YOU SO MUCH. You just saved me literally hours of work.
"Dave O" wrote:
> The formula is
> =LEN(A1)
> Substitute your actual cell reference for A1. This returns the number
> of characters in a string.
>
>
Thanks from me to! So simple and yet saves so much time!
Cheers
Jim
"Dave O" wrote:
> The formula is
> =LEN(A1)
> Substitute your actual cell reference for A1. This returns the number
> of characters in a string.
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks