How do I set a Cell to be a specific text length?

[wrl-2]

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.

[#2 · Accepted solution]

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]

@Twifoo Hey thanks for that. That worked great, perfect! Thank you very much.

[#4]

You’re welcome.