| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Split up
We are trying to split up the file that can sometimes first names together
with last names sometimes first names are after their last names sometimes the city and state and zip is in the same column sometimes indifferent column also sometimes it & Fam which is not a last name this file contains about 30,000 names also advise how to download a sample of the file Mr. H Safir H 1720 51St St Monsey 11204 NY Mr. & Mrs Eli Stern Eli 854 E 24Th St Monsey 11204 NY Mr. Fried & Fam A B 1645 59th St Brooklyn NY 11204 Mr. Hasenfeld & Fam Alex 1655 48th St Brooklyn NY 11204 Mr. Schwartz & Fam Chaim 1620 44th St Brooklyn NY 11204 Mr. Salamon & Fam Elia 5424 16th Ave Brooklyn NY 11204 Mr. H 1720 51st St Brooklyn NY 11204 Mr. Lefkowitz & Fam H 1682 45th St Brooklyn NY 11204 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Split up
I dont think you are going to find a fix for this!, you may be able to lessen the problem using Text to Columns and worksheet functiosn LEFT, MID & RIGHT, but nothing will completely fix what you describe. -- CellMan ------------------------------------------------------------------------ CellMan's Profile: http://www.thecodecage.com/forumz/member.php?userid=6 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=41038 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Split up
"CellMan" wrote in message
... I dont think you are going to find a fix for this!, you may be able to lessen the problem using Text to Columns and worksheet functiosn LEFT, MID & RIGHT, but nothing will completely fix what you describe. -- CellMan ------------------------------------------------------------------------ CellMan's Profile: http://www.thecodecage.com/forumz/member.php?userid=6 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=41038 To whom are you talking ? The "forum" that you are posting in leaches off the Microsoft News servers in order to make it look far busier than it really is. Everyone who uses the MS News servers sees your post on it's own - we have NO IDEA to whom you are talking. If you MUST continue to post in this "forum" then please at least quote the post you are replying to, and do NOT change the subject line. You would be far better off however, using a news reader and subscribing to these news groups direct. Setting up Outlook Express/Windows Mail to access Microsoft newsgroups http://www.michaelstevenstech.com/ou...snewreader.htm Accessing the MS newsgroups in Outlook Express/Windows Mail Newsreader http://www.microsoft.com/windowsxp/e...roupsetup.mspx Thank you -- Asking a question? Please tell us the version of the application you are asking about, your OS, Service Pack level and the FULL contents of any error message(s) |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Split up
Cellman please explain what you mean
"Gordon" wrote: "CellMan" wrote in message ... I dont think you are going to find a fix for this!, you may be able to lessen the problem using Text to Columns and worksheet functiosn LEFT, MID & RIGHT, but nothing will completely fix what you describe. -- CellMan ------------------------------------------------------------------------ CellMan's Profile: http://www.thecodecage.com/forumz/member.php?userid=6 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=41038 To whom are you talking ? The "forum" that you are posting in leaches off the Microsoft News servers in order to make it look far busier than it really is. Everyone who uses the MS News servers sees your post on it's own - we have NO IDEA to whom you are talking. If you MUST continue to post in this "forum" then please at least quote the post you are replying to, and do NOT change the subject line. You would be far better off however, using a news reader and subscribing to these news groups direct. Setting up Outlook Express/Windows Mail to access Microsoft newsgroups http://www.michaelstevenstech.com/ou...snewreader.htm Accessing the MS newsgroups in Outlook Express/Windows Mail Newsreader http://www.microsoft.com/windowsxp/e...roupsetup.mspx Thank you -- Asking a question? Please tell us the version of the application you are asking about, your OS, Service Pack level and the FULL contents of any error message(s) |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Split up
dk wrote:
We are trying to split up the file that can sometimes first names together with last names sometimes first names are after their last names sometimes the city and state and zip is in the same column sometimes indifferent column also sometimes it & Fam which is not a last name this file contains about 30,000 names also advise how to download a sample of the file Mr. H Safir H 1720 51St St Monsey 11204 NY Mr. & Mrs Eli Stern Eli 854 E 24Th St Monsey 11204 NY Mr. Fried & Fam A B 1645 59th St Brooklyn NY 11204 Mr. Hasenfeld & Fam Alex 1655 48th St Brooklyn NY 11204 Mr. Schwartz & Fam Chaim 1620 44th St Brooklyn NY 11204 Mr. Salamon & Fam Elia 5424 16th Ave Brooklyn NY 11204 Mr. H 1720 51st St Brooklyn NY 11204 Mr. Lefkowitz & Fam H 1682 45th St Brooklyn NY 11204 Basically what cellman is saying is that there isn't any consistent pattern. So coming up with a method of laying out this data will be quite difficult if not impossible. If you could divide up that data somehow so that each row had a consistent pattern like all rows with last names fist then you might be able to deal with it in groups. gls858 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I remove split a split window? | New Users to Excel | |||
| Un-Split | Excel Discussion (Misc queries) | |||
| Split box | New Users to Excel | |||
| split bar | Charts and Charting in Excel | |||
| Split a Value | Excel Discussion (Misc queries) | |||
Hybrid Mode
