merge and justify data

[fred]

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/

 

[Guest]

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.