Concatenate two text fields BUT Left adjust first field and Right adjust second field

[ahennema]

I want to concatenate two Cells into a single cell BUT have the first field left justified and the second cell right adjusted.

A1 = "John Williams", A2= "Single"

A3 = "John Williams Single"

Anyone have, a hopefully fairly straight forward, method for completing the above task?

Thanks - Arich

 

[jeffreybrown]

How about

=A1&" "&A2