Sorting when data is on 2 rows???

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
 
A

AC_VID

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

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

Top