ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Separate data align on same cell (https://www.excelbanter.com/excel-programming/394492-separate-data-align-same-cell.html)

k2c

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!

Rich J[_2_]

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!


k2c

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