View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Urgent ..Need help

On Sat, 22 Dec 2007 20:34:00 -0800, Emilio
wrote:

I had a digital calendar with more than 1500 contacts saved in it. Now it's
broken and the company gave me the info saved, but instead of the data to be
organized separatly ( name, home address, phone (H), phone(W)..etc), it's all
mixed.
I don't know if there is an easy way to do this. I'm thinking if there is a
command to delete, cut or move the information that come after the first
number, for instance.
guys, m dealing with 1500 name, each with home phone number, mobile, email,
addresses.. i would appreciate any helpppp, Thanks


You'll need to be more specific when you write "it's all mixed".

If there is no particular format, and person A's address is next to person B's
name, then you wouldn't be able to fix it no matter what.

If there is some kind of consistency in the way things were "all mixed", that
could be used to reorganize the data, that was not clear in your plea.
--ron