How to Arrange mismatch Data

[niladri20052006]

Hi All,

In an excel sheet I have 2,000+ records where I have company name, First Last Name,Email website, Main Phone, Address etc. But the data are in a mixed up way. For example in company name field there are website or main Phone, in email ID field there is website etc. over all the data is completely mixed up.

Is there any way to arrange these data in a proper format?

Will I have to apply VBA?

Please suggest!

 

[venkat1926]

you can distinguish email as it will contain "@"
simiarly webpage can be distinguished as it contains "http"

you can use search function and to put them in proper place. It all depnds upon your database. will it be possible for you to post a VERY SMALL extract of your mixed up database.