On Fri, 2 Jun 2006 15:24:50 -0500, "Some Dude" <sdatt@myplace.com> wrote:

>A1 = 1234
>A2 = 5
>
>B1 = project 1
>B2 = project 2
>
>If I do this in C1
>=concatentate(A1," ",B1)
>I get
>1234 project1
>for C1. That's fine but doing the same thing for row 2 gets me
>5 project 2
>
>I need a way to do this (without a macro because I'm totally helpless when
>it comes to macros) so that Column C lines up everything in Column A AND
>everything in column B so the data is in 1 cell and the "p" in project lines
>up vertically no matter how many characters are in the number in Column A.
>The data HAS TO be in a single cell - no merging cells and changing border
>colors to make it appear that way.
>I think I need something in my concatenate that assigns a set number of
>spaces to the data in Column A and concatenates Column B data starting in
>the same position every time.
>But how?
>

You could try something like:

=CONCATENATE(REPT(" ",6-LEN(A1)),A1," ",B1)

Replace 6 by the largest length of the numbers in column A.

You will need to use a fixed space font -- something like Courier New -- in
order to align this properly.


--ron