LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default how to move all info in column a to seperate columns

I am copying a phone/address directory and want to put it in columns.

This is how it looks when I copy it to excel:

Doe, Jane Ms.
Title/Position: Vice President
Department: Department of Marketing
Office Location: New York
Email:

Doe, John
Title/Position: President
Department: Department of Business
Office Location: New York
Email:


How do i get name to column a, title into column b and so on?

Thanks

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lookup info in one Column and then returning info in other columns Cyndi513 Excel Worksheet Functions 1 June 23rd 08 02:36 PM
Functions that will move info to a different location in column Bill R Excel Worksheet Functions 8 December 10th 07 11:36 PM
seperate first 2 lines of column in seperate columns in same row Glynnhamer Excel Discussion (Misc queries) 2 October 9th 06 04:23 AM
HOW DO I SEPERATE INFO FROM ONE INTO TWO COLUMNS? help needed Excel Worksheet Functions 2 August 12th 06 12:01 AM
Seperate Data in one column into two columns? Dan B Excel Worksheet Functions 4 June 30th 06 09:20 PM


All times are GMT +1. The time now is 07:20 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"