+ Reply to Thread
Results 1 to 4 of 4

3 dots appear before or after the word rather than appearing in the middle of it

  1. #1
    Forum Contributor
    Join Date
    04-13-2017
    Location
    Buchares
    MS-Off Ver
    2016
    Posts
    117

    Red face 3 dots appear before or after the word rather than appearing in the middle of it

    Hey Guys,

    I want to crop and fit any sentence available into a fix space, the after clicking it , the entire sentence will be displayed into a message.

    If I set a maximum of let's say 50 character on some words you can find "te.." or deman..." insted of "test..." or "demand..." <--- i know this may break the logic of the "50 characters limit"

    The function to set a limit is easy, but i dont know how to adapt it to my needs to fit the request above.
    Please Login or Register  to view this content.
    Added attachment with a few sentences to be easy to fix

    Thank you.
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2024
    Posts
    6,175

    Re: 3 dots appear before or after the word rather than appearing in the middle of it

    Try:
    Please Login or Register  to view this content.

  3. #3
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,863

    Re: 3 dots appear before or after the word rather than appearing in the middle of it

    Other idea :
    Please Login or Register  to view this content.
    Best Regards,

    Kaper

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: 3 dots appear before or after the word rather than appearing in the middle of it

    Another way:

    A
    B
    C
    D
    1
    In
    Out
    Len
    2
    On the Insert tab, the galleries include items that are designed to coordinate On the Insert tab, the galleries include items…
    47
    B2: =TrimLen(A2, 50)
    3
    You can use these galleries to insert tables, headers, footers, lists, You can use these galleries to insert tables,…
    46
    4
    When you create pictures, charts, or diagrams, they also coordinate When you create pictures, charts, or diagrams,…
    47
    5
    You can easily change the formatting of selected text in the document You can easily change the formatting of selected…
    49
    6
    You can also format text directly by using the other controls on th You can also format text directly by using the…
    47
    7
    Most controls offer a choice of using the look from the current Most controls offer a choice of using the look…
    47
    8
    To change the overall look of your document, choose new To change the overall look of your document,…
    45
    9
    To change the looks available in the Quick Style gallery, To change the looks available in the Quick Style…
    49
    10
    Both the Themes gallery and the Quick Styles gallery provide reset command Both the Themes gallery and the Quick Styles…
    45
    11
    On the Insert tab, the galleries include items that are designed to coordinate On the Insert tab, the galleries include items…
    47


    Please Login or Register  to view this content.
    Last edited by shg; 11-02-2018 at 09:17 AM.
    Entia non sunt multiplicanda sine necessitate

+ 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. Horizontal axis appearing in middle of chart, but set to bottom center.
    By regupnorth in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 02-21-2016, 05:34 PM
  2. [SOLVED] Formula to get the middle word
    By krazyhype19 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-28-2014, 04:49 AM
  3. How to have the word COMPLETED appearing when all aswers are YES
    By pleasebepatient in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-25-2013, 03:09 PM
  4. [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
  5. Replies: 2
    Last Post: 04-19-2012, 02:16 PM
  6. Sort by middle word?
    By brotherwo in forum Excel General
    Replies: 6
    Last Post: 03-10-2011, 05:58 PM
  7. Replies: 3
    Last Post: 07-06-2005, 07:05 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