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

I'm a bit confused - do you need Data--Sort?

Also, =LEFT([Cell],[No. of characters]) gives you the first 3, 10 or
whatever characters in a cell, if that's what you wanted to do.

"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

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