Email firstname.lastname@example.org to sign up to receive news and updates
This article is about a type of poem called acrostic and how to make them. Of the poems that I've written (which can be found here), of them are acrostic poems.
Here are a few examples of my acrostic poems:
energy warm and puffed up going rapidly in a linear fashion obtuse movement of ogres stomping
gorgeous blond over-active and jumbo one and only loving dirty
Notice how the bolded letters make words. In the second acrostic poem, I have two bolded words. You will often see acrostic poems with just one "hidden" bolded word, usually made from letters at the start of each line. However, the number of bolded words and where they appear in an acrostic poem is only limited by your imagination. I will now show a method that I use to help make these acrostic poems.
As usual, I use Excel to assist with poetry. I have a huge dictionary of words that I regularly update in a column in Excel. I think of a topic that I want the bold letters to be, and enter these bold letters into separate cells. Next, I use some code to indicate (ie. = 1) if the dictionary words have the inputted letter in their first place, or last place, etc. For example, the formula mid(cell,1,1) gives the first letter of a word in a cell, and the formula right(cell,1) gives the letter in the last place of a word in a cell. I will make an indicator column for each letter I want bolded in the acrostic poem.
After I make these indicator columns, I use more complicated formulas to randomly sample from those cells with indicator = 1. In other words, it is like randomly sampling from a column, but only randomly sampling from those cells that have words with the first letters that I want. If column A has the dictionary words and column B has the indicators, the formula is
Instead of pressing Enter after you type this formula, press Ctrl-Shift-Enter, which will enter this formula as an array. Then, it will appear as
Pressing F9 will refresh the random selection of words that have your inputted first letters.
Please check out an example spreadsheet here, with a dictionary of about 5,000 words, and using "good" and "dog" just like in my Acrostic 5 above. You are free to edit the spreadsheet as needed, but if you use this idea, please credit Statisticool.com.
Thanks for reading.
Please anonymously VOTE on the content you have just read:Like:
For poetry, I recommend:
- High Quality Every Day Carry (EDC) Bolt Action Pens & Pencils by Bastion. Use discount code JS20 to get 20% off!
- Shop at The Poet Life store
Please show me a randomly selected poem
If you enjoyed any of my content, please consider supporting it in a variety of ways:
- PLEASE take a moment to check out two GoFundMe fundraisers I set up. The idea is to make it possible for me to pursue my passions. My goal is to be able to create free randomized educational worksheets and create poetry on a full-time basis. THANK YOU for your support!
- Email email@example.com to sign up to receive news and updates
- Donate any amount via PayPal
- Take my Five Poem Challenge
- Subscribe to my YouTube channel
- Visit my Amazon author page
- Buy what you need on Amazon using my affiliate link
- Follow me on Twitter here
- Buy ad space on Statisticool.com
AFFILIATE LINK DISCLOSURE: Some links included on this page may be affiliate links. If you purchase a product or service with the affiliate link provided I may receive a small commission (at no additional charge to you). Thank you for the support!