Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Aligning Data Within Merged Cells
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Define a maximum length for both column (Number:A, Text:B), let's say 10, then:
=REPT(" ";10-LEN(TEXT(A3;"0,0")))&TEXT(A3;"0,0")&REPT(" ";10-LEN(B3))&B3 Regards, Stefi €˛Steve Almond€¯ ezt Ć*rta: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
retrieve text from merged cells | Excel Worksheet Functions | |||
requires that merged cells must be identically sized? | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) | |||
REPOST: How can I make the graph omit blank cells in the data set? | Charts and Charting in Excel | |||
How do I copy data (word) into respective cells when the data bei. | New Users to Excel |