Forum Discussion
Solved
How do I set a Cell to be a specific text length?
Hi. If the text word for example "Washing Machine" was entered into a cell, that entry would be 15 characters in length. How do I create a Cell, a Row or Column so that when I copy/paste a wh...
- If you are willing to accept a Helper Column, and assuming that the words are pasted in Column A, you may enter this formula in B1, copied down rows, to extract the first 10 characters:
=LEFT(A1,10)
If you are willing to accept a Helper Column, and assuming that the words are pasted in Column A, you may enter this formula in B1, copied down rows, to extract the first 10 characters:
=LEFT(A1,10)
=LEFT(A1,10)
