Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
BRyan
 
Posts: n/a
Default Copy information from one cell to several different cells

I received an Excel document that has 2000 plus names and addresses, however
they put the name and address together in one cell and I need them in
seperate cells so I can sort on the address. Is there a way I can take the
information in one cell and move it to several different cells, without
having to cut and paste every one of the 2000 cells.
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Billigmeier
 
Posts: n/a
Default Copy information from one cell to several different cells

If they are separated by a common delimiter, you can use the Data-'Text to
Columns...' feature.


--
Regards,
Dave


"BRyan" wrote:

I received an Excel document that has 2000 plus names and addresses, however
they put the name and address together in one cell and I need them in
seperate cells so I can sort on the address. Is there a way I can take the
information in one cell and move it to several different cells, without
having to cut and paste every one of the 2000 cells.

Reply
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
checking that cells have a value before the workbook will close kcdonaldson Excel Worksheet Functions 8 December 5th 05 05:57 PM
Transfer Cell Formatting for linked cells Scott Excel Discussion (Misc queries) 2 November 24th 05 12:04 AM
How to Copy the value of a cell to any given cell Memphis Excel Discussion (Misc queries) 4 October 21st 05 08:29 PM
How do I copy a comment to become the information in a cell. Patrick from RAS Excel Discussion (Misc queries) 1 August 24th 05 06:45 AM
Copy cells into range of cells until cell change mdeanda Excel Worksheet Functions 1 April 22nd 05 08:41 PM


All times are GMT +1. The time now is 04:53 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"