Hi guys, I really hope somebody here can help me with the LEN function in excel. I have looked everywhere for the solution but I just can't figure out what it is I need to do.
I am an excel novice so please explain in as basic and concise terms as possible.
My problem is this...
I have an excel sheet of about 5,000 rows in length and one column wide.
Each cell A1 to A5000 contains a line of text.
Approximately 4 of the cells have text which is too long for my purposes*.
How can I enter a formula which gives me the number of characters in each cell/row?
Eg:
Row Column A
...1. Nobby2020example1/excelproblem
...2. Nobby2020example1/excelproblem is difficult to figure out
...3. Nobby2020example1/excelprob
...4. Nobby2020example1/excelproblem/frustrated user
...5. Please helpmefigure.this/out
I can find the number of characters in a single cell by doing the forumla =len(a1) and it gives me the number of characters for cell A1.
But I need the number of characters for each cell individually.
What I presume I need is an automated way to put the formula in next to each cell so...
Row Column A ...... Column B
...1.... =len(a1) ...... Nobby2020example1/excelproblem
...2.... =len(a2) ...... Nobby2020example1/excelproblem is difficult to figure out
...3.... =len(a3) ...... Nobby2020example1/excelprob
...4.... =len(a4) ...... Nobby2020example1/excelproblem/frustrated user
...5.... =len(a5) ...... Please helpmefigure.this/out
But without having to write the formula in every cell.
Hope you can help, I presume the answer is obvious really.
Thanks
Bookmarks