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
A1 = "John Williams", A2= "Single"
A3 = "John Williams Single"
Anyone have, a hopefully fairly straight forward, method for completing the above task?
Thanks - Arich