Sorting when data is on 2 rows???

  • Thread starter Thread starter RECW
  • Start date Start date
R

RECW

I have data presented on rows as follows:

1 128655 Black, Robert 9:00 AM Breakfast meeting at Holiday
2 Inn. Casual.
3 123456 Blow, Joe 4:30 PM Customer wants to come
4 in to visit
about a new
5 business
venture.

How can I sort Column 1 (128655 and 123456) so that Row 2 information stays
with 128655 and row 4 and 5 stays with 123456?

Can I be done?

TIA,

Ron
 
Why do you write the meetings details on 2 or 3 rows instead of writing in
the SAME cell ?

Format the column that contains the meeting details info to wrap the text in
the SAME cell
Highlight the range then go to : Format cells/Alignement and check the box
called wrap text.
This will leave all the info in the same cell and it will be contained in
the SAME row as the numbers 128655 or 123456.
The disadvantage maybe that the row will be higher than the others.
You can also try to widen the cell if it doesn't matter.
=====================
 
Back
Top