Max,

Does that mean that you answered your own question or...?

Otherwise, the formula you are trying to use won't work as it is. You wrote:
=CONCATENATE(R4,\" \",S3)

Try something like:
=CONCATENATE(R4," \",S3)

And I don't know what your spreadsheet looks like, but in the above formula
you would be asking excel to put the value of r4 and then \ and then the
value of s3. The reason I question that is cell s3 is one cell up and one
cell to the right of r4.

As far as lining up the numbers to a far right edge, why couldn't you leave
them in separate columns, or your answer in separate cells? That would be the
easiest thing to do. Meaning, cell a1 you select the product number, and in
cell b1 shows the Desc, and in c1 shows the id no.