Forum Discussion

wrl-2's avatar
wrl-2
Copper Contributor
May 10, 2019
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 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

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    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)
    • wrl-2's avatar
      wrl-2
      Copper Contributor
      Twifoo Hey thanks for that. That worked great, perfect! Thank you very much.

Resources