text to columns

Hello - One of my clients sent me a file of addresses that seems to have been pulled from some sort of database and the formatting on the addresses is a little sloppy. Every line of the address is in one cell and there are some extra characters which excel isn't reading quite right (these...

I have Employee Names such as: John Violet Mary jr Dsouza B n Chandra I want to split it into two columns, at all places where there is a capital Character. Such as John Violet Mary jr Dsouza B n Chandra --------------------- Regards, ~Vani~

I have thousands of lines of data that are of the following form: Jackson, TN 9623 BCBS TN 98 UnitedHlthCare 2<o:p></o:p> Jacksonville, FL 3577 Aetna 47 BCBS FL 37<o:p></o:p> Knoxville, TN 3796 Cariten 44 John Deere 41<o:p></o:p> Lakeland-Winter Haven, FL 2165 UnitedHlthCare 31 Aetna 29...

Does anyone know the syntax to convert text to table using 2 delimiters (~ to switch to the next column and "&" to switch to the next row)? I'm planning to use it as part of a macro for MS Project 2003 but I figure it would be pretty much the same in excel. Any help would be greatly appreciated.

Hi all, I've been using the forums for several days to get answers to my questions but finally came across a dead end. Please help! I'm working with a dataset where there is a whole bunch of text in one cell that I need to parse. There are two delimiters: "~" and ";". Furthermore, there are...

My data looks like this: Cell A9 - Backplate 1-2 weeks 14 Cell A10 - Carbon Wall Mounts 1-2 weeks 14 Cell A11 - AP Mount 1-2 weeks 14 Cell A12 - AP Power Pack Mount 1-2 weeks 14 I want to do some kind of text to columns or formula or something that will leave me with: Cell A9...

I have a general idea where I want to go with this. But I am looking for guideance on how to do it. I have a column with something like this: 5 of 10* or 245 of 390 I want to separate this into two or more columns. Sure I can easily do it with a formula or even the Text to Columns menu option...