Question about Function =LEN(cell) - Cell Character Count

[jakecc]

Hi Folks!

I have a spreadsheet that I'm working on for a client and each cell cannot exceed 26 characters. In performing a Google search, I came across the function =LEN(cell). My questions is this, would it be possible to compose this function in a way that it would process an entire column with each target cell's output to be placed in a neighboring cell within the row? For instance, I'd like for cell 2 in column a to house the character count for cell 2 in column c, with cell 3 in column a housing the character count for cell 3 in column c, and so on. I'd like to avoid having to enter the function for each of the 869 rows within the spreadsheet. Manually counting the characters within each cell is rather difficult and entering the function on each row is difficult as well.

Thanks in advance!

Jake

 

[vavs]

If you type Len(c2) in column A and copy it down you will get the counts for each row in Column A. You don't need a function to get this result. I would put a filter on the column and then filter any value greater than 26.

 

[jakecc]

If you type Len(c2) in column A and copy it down you will get the counts for each row in Column A. You don't need a function to get this result. I would put a filter on the column and then filter any value greater than 26.

THANK YOU SOOOOOOOOOOOOOOOOOOOOOOOOOOOOO MUCH!!!!

I wish you a great day!

Jake