Results 1 to 7 of 7

Help trying to align cells by symbol / character

Threaded View

  1. #1
    Registered User
    Join Date
    09-22-2015
    Location
    England
    MS-Off Ver
    2013
    Posts
    3

    Help trying to align cells by symbol / character

    Hi all,

    I'm trying to replicate a table format from a paper,

    They have centre aligned the following cells by the ± symbol. I have searched online and only found aligning by decimal.

    Example input (1 column, 3 rows)
    536 ± 49.2
    68.4 ± 48
    502.9 ± 39.4

    I would be very grateful for any advice!

    Edit For those interested the Table I'm trying to copy is here http://link.springer.com/article/10....-0690-4#page-1

    Update: Solved!

    Alex Frolov, http://superuser.com/questions/97654...ls-by-a-symbol
    Please create the helper column with the following formula

    =REPT(" ",10-FIND("±",A1))&A1

    where A1 - your original string and 10 - the maximal number of characters before "±" in your data

    Then apply the monotype font (e.g. "Courier new") to this column
    Last edited by markieg1; 09-23-2015 at 03:51 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Remove blank character and change the character (or symbol)
    By vutienhp in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-02-2015, 11:55 PM
  2. Paste strings of multiple lengths into word and right-align last character ???
    By frankienap in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-17-2014, 03:54 PM
  3. Insert Character/Symbol At The Start of Each Word
    By byepeeps in forum Excel General
    Replies: 2
    Last Post: 06-08-2010, 12:50 PM
  4. Have a symbol appear when I type a certain character
    By AngelHelp in forum Excel General
    Replies: 15
    Last Post: 07-10-2008, 01:50 PM
  5. Need to align text around a symbol???
    By guillemot in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-18-2006, 12:43 PM
  6. List of Symbol and Character Number
    By Polina in forum Excel General
    Replies: 4
    Last Post: 05-05-2005, 08:06 PM
  7. [SOLVED] How do I create a new symbol to enter as a character?
    By Coryne17 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-20-2005, 01:06 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