How to count all characters in a cell of current row in Excel?
I am trying to use this function =LEN() to count the characters of 1000+
cells, but I can't find a way of just copy-paste it and make it efficient.
If I write the cell id manually =LEN(A1) it works pretty fine, but I want
to write something like the following, so I can copy-paste it a thousand
times: (Now, bare with me, I've never used excel before and I know next to
nothing of its syntax)
=LEN(A*current_row*)
I just want to get the current row, I don't care for the current column.
Thanks very much.
Oh, and just in case you know a different way to count the characters of
all the different cells on a row and having the results not summed in a
big number, please, I'm all ears and eyes.
No comments:
Post a Comment