+ Reply to Thread
Results 1 to 3 of 3

Is There An Easier Way and Ability To Enter Larger Texts / Bible Verses?

  1. #1
    Registered User
    Join Date
    03-07-2022
    Location
    Tallahassee, Florida
    MS-Off Ver
    365
    Posts
    6

    Question Is There An Easier Way and Ability To Enter Larger Texts / Bible Verses?

    Hi,

    I created a spreadsheet that takes a string of text (specifically Bible verses from the King James Bible) and then will allow you to create another string of text from the original string of text pulling every 3rd letter, or 4th letter or 7th letter, etc., etc. Bible numerics if you will... In other words when I type in the first few words of Genesis 1:1 "inthebeginninggodcreated" and I have it set for every 8th letter, it renders the letters "GOD". Another example is Luke 2:21... When I type in the first 4 words of this verse "andwheneightdays" speaking about when JESUS was circumcised, and have it set for every 3rd letter, it renders the letters "DEITY". So, that's what my program does now... I'd like to be able to find a way to make it accept a larger chunk of text more easily... How can I do this?

    Thanks!

    Bruce Roberts

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,643

    Re: Is There An Easier Way and Ability To Enter Larger Texts / Bible Verses?

    You can copy/paste from an online bible and remove spaces and verse numbers...
    Ben Van Johnson

  3. #3
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Is There An Easier Way and Ability To Enter Larger Texts / Bible Verses?

    Cross-posted at: https://www.mrexcel.com/board/thread.../#post-5847692
    Please read Excel Forum's Cross-Posting policy in rule 8: http://www.excelforum.com/forum-rule...rum-rules.html
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 01-13-2021, 10:52 PM
  2. Replies: 11
    Last Post: 04-09-2019, 09:50 AM
  3. Replies: 1
    Last Post: 07-10-2017, 01:36 PM
  4. Need to separate Alt+Enter texts to individual cells
    By Sekars in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-27-2017, 08:16 AM
  5. Replies: 4
    Last Post: 12-26-2005, 01:55 PM
  6. [SOLVED] Should have ability to right click to accept autosum, not Enter.
    By Spotter21 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-09-2005, 08:35 PM
  7. [SOLVED] HELP! I Lost The Ability To Advance From TextBox To TextBox With the ENTER Or The TAB Keys
    By Minitman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-22-2005, 06:51 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1