Sorting when data is on 2 rows???

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RECW - 26 Sep 2003 21:01 GMT

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

Reply to this Message

AC_VID - 18 Oct 2003 07:03 GMT

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.
=====================

> I have data presented on rows as follows:
>
[quoted text clipped - 14 lines]
>
> Ron

Reply to this Message