LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
bj
 
Posts: n/a
Default

depending on the format there are several methods.
I would try <data<text to columns first

"Cody" wrote:

I receive many spreadsheets where the sender combines the address, city,
state and zip in one cell/column. I would like to know the formula to
fragment or explode all this data into separate cells/coumns.

 
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
When entering data into excel spreadsheet cell, the page just jump jodj Excel Discussion (Misc queries) 1 March 1st 05 05:51 PM
Import Data into same cell ib_redbeard Excel Discussion (Misc queries) 3 March 1st 05 12:08 PM
I want a window to cell data that conains links to PDF files and . WEATHER TECH. NOT A ROCKET ENGINEER Excel Discussion (Misc queries) 1 February 24th 05 08:21 PM
Repeat Cell Data Pinky Excel Worksheet Functions 1 January 18th 05 05:38 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


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