LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Gary in Alaska
 
Posts: n/a
Default MSExcel--words in a cell separated by comma need to be moved into.

I have a Excel spreadsheet that has complete addresses in one cell. (ie 123
Washington Street, Seattle WA 98111). I wish to put each item in separate
cells for use in a database. Is there an easy way to do this using a function
or ??
 
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
Excel formula for seperating two words in the same cell. Mim New Users to Excel 2 March 8th 05 11:33 PM
How do I transpose Comma Separated Data in each cell and delete t. randy Excel Discussion (Misc queries) 2 February 15th 05 11:07 PM
How do i merge data in a row of cells to be comma separated in on. Banana Excel Discussion (Misc queries) 1 February 7th 05 05:42 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM
Count the number of words in a cell! Doom3 Excel Worksheet Functions 4 November 23rd 04 06:00 AM


All times are GMT +1. The time now is 07:53 AM.

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

About Us

"It's about Microsoft Excel"