Hi Annie,

Since rearranging data is of interest you might take a look at using the mouse
I'd put the phone number first (right justified even as text), lastname, firstname, addresses, etc.

Fill-Handle, Replication and use of the Mouse
Use of Mouse and keys to move, and insert rows or columns (#mouse)
http://www.mvps.org/dmcritchie/excel/fillhand.htm#mouse

Shortcut Keys in Excel 2000 (Excel Vers. 9)
http://www.mvps.org/dmcritchie/excel/shortx2k.htm

Excel Lessons & Tutorials (#tutorials)
http://www.mvps.org/dmcritchie/excel....htm#tutorials
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm