Separate data align on same cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Separating data in the same cell 1
Best way to get data from Access 2003 to Excel 2003 6
Copy excel cell to webform (search box) and press enter 10
Merge data by macro 9
How to delete ALL cells containing the same data 1
Data Validation -> Validation list is larger than the cell width 1
Append name in the same cell with ' ' 3
Combine two cells without losing data cell formats 2

Back
Top