Hello I have a succession of contact data in the form of: NAME, A.B. Address Address Address Address Phone: 000-000 Fax: 000-000 E-Mail: aaaaa@mts.net (one to 3 blank rows) new contact .. They all are in the first column of an XL sheet. What I like to have is each info in a different column and a succession of contact rows. If possible also eliminate the blank rows and part of the text in a cell (e.g. Phone: or Fax: ) Is it possible to do that without having to to go throught each single record ??? Thank you very much for helping I appreciate! Martie

Yes, Use Paste Special, Transpose. This would not delete empty fields. I would not delete empty fields because you would lose the ability to search and sort. Example: Column 6 - phone number After transformed you can trim phone and fax from those cells.

Thanks Fred! That is great and works well. But i have to do it one by one ..and i have over 300 entries, is there a way for transforming the whole fist column?? And how do I "trim" phone and fax without doing it cell by cell? Thanks a lot for helping Martie

Not sure what you mean about trimming phone and fax. If you mean change Phone to Ph and Fax to Fx then use Find and Replace after selecting the entire first column. The other process...that's what macros were made for. I can't write it due to lack of ability but the folks at the OzGrid Excel forum are quick to offer their expertise in those matters. I have not presented them with a problem they couldn't handle yet. As a courtesy, use the Search function before registering and posting your problem. It may be there already. Regards, Bryan

If your entries are name1 (a1.a11), name2 (a12.a22), etc. The only way I can think of is to create a macro that will allow you to select the input range, then the output row. Unfortunately, from my interpetation of the structure of your data, Phone and Fax does not necessarily end up in the same column. Otherwise, one of the TEXT functions (MID$ or RIGHT$) could be used to trim the prefix. A macro could also be used. My recommendation is to normalize the structure so that the field data are all in columns. Even though you will have empty cells, you will know that column 6 is the phone number. Maybe the next step is to go to a data base or a contact manager.

Thanks to all of you, much appreciated! Martie