SOLVED

Sign Board

%3CLINGO-SUB%20id%3D%22lingo-sub-2074809%22%20slang%3D%22en-US%22%3ESign%20Board%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2074809%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20simplify%20my%20life%20a%20bit%20and%20looking%20for%20some%20help.%26nbsp%3B%20This%20is%20for%20setting%20out%20statements%20that%20need%20to%20be%20posted%20on%20our%20community%20signboard.%26nbsp%3B%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EI%20would%20like%20to%20be%20able%20to%20enter%20in%20a%20statement%20-%20%22zoom%20meeting%201%2F20%206pm%20see%20NextDoor%20for%20info%22%20and%20have%20formulas%20set%20to%20break%20that%20out%20into%204%20lines%20of%20no%20more%20than%2013%20characters%20each%20line.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20to%20have%20this%20displayed%20in%20a%20grid%20showing%20the%20layout%20of%20each%20letter%20to%20assist%20in%20placement%20on%20the%20board.%26nbsp%3B%20This%20would%20take%20each%20line%20and%20break%20it%20up%20into%201%20letter%20per%20cell.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20then%20have%20a%20letter-number%20grid%20for%20counting%20the%20number%20of%20letters%20and%20numbers%20that%20need%20to%20be%20pulled%20for%20placement%20on%20the%20board.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESee%20attached%20for%20examples%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance%20for%20any%20and%20all%20assistance%20with%20this.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2074809%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

I am trying to simplify my life a bit and looking for some help.  This is for setting out statements that need to be posted on our community signboard.  

I would like to be able to enter in a statement - "zoom meeting 1/20 6pm see NextDoor for info" and have formulas set to break that out into 4 lines of no more than 13 characters each line.  

 

Then to have this displayed in a grid showing the layout of each letter to assist in placement on the board.  This would take each line and break it up into 1 letter per cell.

 

I would then have a letter-number grid for counting the number of letters and numbers that need to be pulled for placement on the board.  

 

See attached for examples

 

Thank you in advance for any and all assistance with this.  

2 Replies

@3inproverbs 

In the attached workbook (.xlsm, make sure you allow macros when you open it), I added a Worksheet_Change event procedure that will populate C4:C7 and F4:R7 when you change the text in C1.

The result is slightly different from your example.

best response confirmed by 3inproverbs (New Contributor)
Solution

@Hans Vogelaar  This is EXACTLY what I have been wanting.  Thank you so much for your assistance!