merge and justify data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

fred - 27 Oct 2006 01:37 GMT

Hi,

I have data in the following format:
A1 B1
123 1223
12 2356

What I would like to do is be able to
merge and justfiy into column C1.
A1 B1 C1
123 1223 123 1223
12 2356 12 2356
Using the formula -=a1&" "&b1
I accomplish this. However I would like to justify the data so the data is
like this:
A1 B1 C1
123 1223 123 1223
12 2356 12 2356
1234 69877 1234 69877

Any ideas on how to justify this data/

Reply to this Message

Anne Troy - 27 Oct 2006 13:54 GMT

I cannot imagine how this would be accomplished in Excel (or why you'd even
want to do so, for that matter <grin>). However, if you use a formula such as
=A1&"$$$"&B1, then copy the results into Word, you could find/replace the $$$
with a tab character and set the tab to be right-aligned. This would give
you the layout you're looking for.

Signature

~Anne Troy
www.OfficeArticles.com

> Hi,
>
[quoted text clipped - 17 lines]
>
> Any ideas on how to justify this data/

Reply to this Message