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
Bookmarks