+ Reply to Thread
Results 1 to 2 of 2

Putting a right justify on the last word inside of a cell

  1. #1
    Registered User
    Join Date
    11-29-2009
    Location
    Maine, USA
    MS-Off Ver
    Excel 2013
    Posts
    62

    Putting a right justify on the last word inside of a cell

    I want to use a right justify or last word or the last group of word in and excel cell.
    Is this possible?

    I have included an attachment of how I would like it to turn out.
    In the attachment I and using GPS coordinates as my example.
    After "Gap." I would like to make everything that follows a right justify.
    Is that at all possible to do?

    excel-jr.jpg

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

    Re: Putting a right justify on the last word inside of a cell

    You would need to replace all of the spaces in the cell save the last with non-breaking spaces (CHAR(160)), and set the horizontal alignment to Distributed (Indent).

    If you do that, however, the lines in the cell will not break at word boundaries.
    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. Find word/phrase within cell & automate putting value in adjacent cell
    By jyeg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-24-2016, 10:44 AM
  2. [SOLVED] Using Sumproduct to find a containing word inside a cell
    By bouncingbudha in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-14-2014, 09:28 PM
  3. [SOLVED] Replacing the word inside the cell
    By shimaa01234 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-24-2014, 08:53 AM
  4. [SOLVED] putting $ in the Range which inside .Formula
    By viva2kh in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-18-2012, 04:14 AM
  5. Can i save 350 word article inside a cell
    By georgiefame99 in forum Excel General
    Replies: 3
    Last Post: 03-30-2012, 02:18 PM
  6. putting an input box inside a macro
    By Drummy in forum Excel General
    Replies: 1
    Last Post: 06-07-2006, 03:15 AM
  7. Replies: 7
    Last Post: 03-04-2005, 03:06 PM

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