You have to use two columns or manually align each one.

"Steve Almond" wrote:

I want to merge two columns of data - one of numbers one of text. This is no
problem, but I want the text to be aligned in the merged cells, not the
numbers. Here is how it appears (hope formatting is OK):

50 XTO 50 XTO
32.5 ZEUS 32.5 ZEUS
417.5 ZEUS 417.5 ZEUS

Here is how I would like it:

50 XTO 50 XTO
32.5 ZEUS 32.5 ZEUS
417.5 ZEUS 417.5 ZEUS

Any help appreciated,

Steve