Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Separate data align on same cell
I have 2 data fields - ID# and Date. They're separated by a space, and
centered in a cell of width 126. Is there a way to place the ID# on the far left of the cell while having the Date on the far right of the same cell? Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Separate data align on same cell
Why are you combining your data into one field ? 126 is almost a whole page width. Why not just put the ID# in one cell and align left and the Date in an adjacent cell and align right ? Seems simpler than concatenating your ID# and date into one cell. "k2c" wrote: I have 2 data fields - ID# and Date. They're separated by a space, and centered in a cell of width 126. Is there a way to place the ID# on the far left of the cell while having the Date on the far right of the same cell? Thanks! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Separate data align on same cell
Indeed... Of course, if I have a choice I would. The data is part of the
content of a report file which I import from another system/application. I guess I could move the date to another column and merge the two columns for subsequent rows. I was hoping if there's a way to format the ID# & Date, it would be less work. "Rich J" wrote: Why are you combining your data into one field ? 126 is almost a whole page width. Why not just put the ID# in one cell and align left and the Date in an adjacent cell and align right ? Seems simpler than concatenating your ID# and date into one cell. "k2c" wrote: I have 2 data fields - ID# and Date. They're separated by a space, and centered in a cell of width 126. Is there a way to place the ID# on the far left of the cell while having the Date on the far right of the same cell? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
separate data from one cell | Excel Programming | |||
separate address data in a cell | Excel Discussion (Misc queries) | |||
Save 2 separate data imports in separate worksheets on the same ex | Excel Worksheet Functions | |||
Split data from one cell to two separate cells | Excel Worksheet Functions | |||
align data in a cell from VB | Excel Programming |