SEARCH

The How-To Geek Forums Have Migrated to Discourse

How-To Geek Forums / Windows XP

How to organize data in Excel

(4 posts)
  • Started 7 years ago by hit
  • Latest reply from hit
  • Topic Viewed 11393 times

hit
Posts: 2

I have got a text file which needs to be organized in Excel.

The data goes something like this.

1. BoBoBo Ltd
Address: 5/F, Joseph Plaza , 14 Dodo Road, Hemisphere Bay, New South Conneticut
Phone: 4546454
Fax: 489798798
E-mail: josephdadada@dadada.com
Website: www.dadada.com.uk
Contact: Mr.Harris Prouder, Group Chairman

What I want to do is put company name, address,phone,fax,e-mail,website and contact as headings. All the others go below their respective headings.

I have got more than a hundred entries like this and organizing them one-by-one is going to be very time consuming. I'd really appreciate any kind of help.

Thanks in advance

Posted 7 years ago
Top
 
supermansghost
supermansghost
Posts: 350

[edit... didn't read your post correctly, my answer was wrong]

Will research...

Posted 7 years ago
Top
 
supermansghost
supermansghost
Posts: 350

Here you are... this is the best way to accomplish this:

http://www.edferrero.com/Blog/.....fault.aspx

Posted 7 years ago
Top
 
hit
Posts: 2

Thanks a lot. That link helped a lot.

Posted 7 years ago
Top
 



Topic Closed

This topic has been closed to new replies.