![]() |
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! |
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! |
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! |
All times are GMT +1. The time now is 06:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com