+ Reply to Thread
Results 1 to 5 of 5

Cross reference letter case: Beginning of sentence and middle of sentence

  1. #1
    Registered User
    Join Date
    02-07-2019
    Location
    Johannesburg
    MS-Off Ver
    2010
    Posts
    2

    Cross reference letter case: Beginning of sentence and middle of sentence

    Afternoon,

    I found this code to change all the cross references to lower case, e.g. "Figure 3 shows ....." becomes "figure 3 shows .....", all cross references change to lower case. I want to add a condition that when the cross reference is in the beginning of a sentence, the case must remain upper case, e.g. ".... after ten years. Figure 3 shows ....." and not ".... after ten years. figure 3 shows ....." but in the middle of a sentence it should be ".... as seen in figure 3..." and not "...as seen in Figure 3..."

    This is the code:

    ```
    Please Login or Register  to view this content.
    ```

    Please assist.

    Regards
    Caswell1000
    Last edited by caswell1000; 02-07-2019 at 10:08 AM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Cross reference letter case: Beginning of sentence and middle of sentence

    Code Tags Added

    Hi and welcome
    Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



    (I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

  3. #3
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Cross reference letter case: Beginning of sentence and middle of sentence

    Oh, and by the way, don't hesitate to show some courtesy like, " Hello" or " Thanks". They are not considered coarse language, and are, indeed, a good introduction to speedy answers

  4. #4
    Registered User
    Join Date
    02-07-2019
    Location
    Johannesburg
    MS-Off Ver
    2010
    Posts
    2

    Re: Cross reference letter case: Beginning of sentence and middle of sentence

    Thank you, apologies for the awful behaviour.
    Last edited by caswell1000; 02-07-2019 at 10:08 AM.

  5. #5
    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: Cross reference letter case: Beginning of sentence and middle of sentence

    Try:
    Please Login or Register  to view this content.
    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. Insert value from cell in middle of a sentence
    By jw191 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-22-2019, 12:53 AM
  2. Automatic capital letter for each sentence First letter - how
    By santbiju1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-10-2015, 06:21 AM
  3. Replies: 1
    Last Post: 04-04-2014, 04:25 PM
  4. [SOLVED] Split Capital case and Sentence case from a cell
    By Latha Mani in forum Excel General
    Replies: 8
    Last Post: 03-26-2014, 03:29 AM
  5. [SOLVED] Copying a word from one cell in a different worksheet into the middle of a sentence.
    By DannyJ in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-25-2012, 11:18 AM
  6. How do you insert a cell's content in the middle of the sentence?
    By simpleonline1234 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-29-2010, 02:56 PM
  7. [SOLVED] How do I change case to sentence case in groups in excel?
    By Pinetree in forum Excel General
    Replies: 2
    Last Post: 05-16-2006, 12:10 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