If your "project #" number never exceeds 9, how about just right
aligning Column C?

Craig

Some Dude 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?
>
>