Forum Discussion
wrl-2
May 10, 2019Copper Contributor
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 whole load of words; Excel will automatically truncate that Cell to a specific text/character length. For example, if I want a single Cell or an entire Column to be set at 10 characters -- when I copy/paste into that Cell all I would see is the word "Washing Ma".
I've tried adjusting the Default Width (of a cell) aka Standard Width 8.43 feature but this doesn't work.
Thanks in advance.
- 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)
3 Replies
Sort By
- TwifooSilver ContributorIf 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)