SOLVED
Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-559674%22%20slang%3D%22en-US%22%3EHow%20do%20I%20set%20a%20Cell%20to%20be%20a%20specific%20text%20length%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-559674%22%20slang%3D%22en-US%22%3E%3CP%3EHi.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20the%20text%20word%20for%20example%20%22Washing%20Machine%22%20was%20entered%20into%20a%20cell%2C%20that%20entry%20would%20be%2015%20characters%20in%20length.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20I%20create%20a%20Cell%2C%20a%20Row%20or%20Column%20so%20that%20when%20I%20copy%2Fpaste%20a%20whole%20load%20of%20words%3B%20Excel%20will%20automatically%20truncate%20that%20Cell%20to%20a%20specific%20text%2Fcharacter%20length.%26nbsp%3B%20For%20example%2C%20if%20I%20want%20a%20single%20Cell%20or%20an%20entire%20Column%20to%20be%20set%20at%2010%20characters%20--%20when%20I%20copy%2Fpaste%20into%20that%20Cell%20all%20I%20would%20see%20is%20the%20word%20%22Washing%20Ma%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20tried%20adjusting%20the%20Default%20Width%20(of%20a%20cell)%20aka%20Standard%20Width%208.43%20feature%20but%20this%20doesn't%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-559674%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-560300%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20set%20a%20Cell%20to%20be%20a%20specific%20text%20length%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-560300%22%20slang%3D%22en-US%22%3EIf%20you%20are%20willing%20to%20accept%20a%20Helper%20Column%2C%20and%20assuming%20that%20the%20words%20are%20pasted%20in%20Column%20A%2C%20you%20may%20enter%20this%20formula%20in%20B1%2C%20copied%20down%20rows%2C%20to%20extract%20the%20first%2010%20characters%3A%3CBR%20%2F%3E%3DLEFT(A1%2C10)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-560760%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20set%20a%20Cell%20to%20be%20a%20specific%20text%20length%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-560760%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%20Hey%20thanks%20for%20that.%20That%20worked%20great%2C%20perfect!%20Thank%20you%20very%20much.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-560782%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20set%20a%20Cell%20to%20be%20a%20specific%20text%20length%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-560782%22%20slang%3D%22en-US%22%3EYou%E2%80%99re%20welcome.%3C%2FLINGO-BODY%3E
wrl-2
New Contributor

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.

3 Replies
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)
@Twifoo Hey thanks for that. That worked great, perfect! Thank you very much.
You’re welcome.
Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies