Urgent ..Need help

E

Emilio

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

It Is Me Here

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

Ron Rosenfeld

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
 

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

Similar Threads


Top