If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
Seperating information in a cell
What formula can be used to sepearte information in a cell and put into
several cells? I exported infromation contained in a pdf file into Excel. In one of the columns each cell has a full name, Street address, City, state and zip. I want to have first name, last name, street address, city, state and zip extracted and put into different columns. Can this be done? |
#2
|
|||
|
|||
Seperating information in a cell
How is the full name shown in the text... last namecomma first name or
simple first name last name? Are there ever any middle names or titles (Mr., Mrs, Dr., etc.)? Rick "andyK" wrote in message ... What formula can be used to sepearte information in a cell and put into several cells? I exported infromation contained in a pdf file into Excel. In one of the columns each cell has a full name, Street address, City, state and zip. I want to have first name, last name, street address, city, state and zip extracted and put into different columns. Can this be done? |
#3
|
|||
|
|||
Seperating information in a cell
The Name is shown in each cell like the following:
First Name Middle Initial Last Name (There are no commas just a space between First Middle and Last name "Rick Rothstein (MVP - VB)" wrote: How is the full name shown in the text... last namecomma first name or simple first name last name? Are there ever any middle names or titles (Mr., Mrs, Dr., etc.)? Rick "andyK" wrote in message ... What formula can be used to sepearte information in a cell and put into several cells? I exported infromation contained in a pdf file into Excel. In one of the columns each cell has a full name, Street address, City, state and zip. I want to have first name, last name, street address, city, state and zip extracted and put into different columns. Can this be done? |
#4
|
|||
|
|||
Seperating information in a cell
What do you put if there is no middle initial (like for my wife... she
doesn't have a middle name)? The reason I ask is if you put nothing, then it will be hard to tell the difference between these to names (I know people with names like these)... Mary Anne Jones (Mary Anne is her full first name) Tom Della Rossa (Della Rossa is his full last name) Rick "andyK" wrote in message ... The Name is shown in each cell like the following: First Name Middle Initial Last Name (There are no commas just a space between First Middle and Last name "Rick Rothstein (MVP - VB)" wrote: How is the full name shown in the text... last namecomma first name or simple first name last name? Are there ever any middle names or titles (Mr., Mrs, Dr., etc.)? Rick "andyK" wrote in message ... What formula can be used to sepearte information in a cell and put into several cells? I exported infromation contained in a pdf file into Excel. In one of the columns each cell has a full name, Street address, City, state and zip. I want to have first name, last name, street address, city, state and zip extracted and put into different columns. Can this be done? |
#5
|
|||
|
|||
Seperating information in a cell
If there is no middle initial then nothing goes as They wanted the first name
column to have either First name alone or First name than a space and then middle initial Thanks, Andy "Rick Rothstein (MVP - VB)" wrote: What do you put if there is no middle initial (like for my wife... she doesn't have a middle name)? The reason I ask is if you put nothing, then it will be hard to tell the difference between these to names (I know people with names like these)... Mary Anne Jones (Mary Anne is her full first name) Tom Della Rossa (Della Rossa is his full last name) Rick "andyK" wrote in message ... The Name is shown in each cell like the following: First Name Middle Initial Last Name (There are no commas just a space between First Middle and Last name "Rick Rothstein (MVP - VB)" wrote: How is the full name shown in the text... last namecomma first name or simple first name last name? Are there ever any middle names or titles (Mr., Mrs, Dr., etc.)? Rick "andyK" wrote in message ... What formula can be used to sepearte information in a cell and put into several cells? I exported infromation contained in a pdf file into Excel. In one of the columns each cell has a full name, Street address, City, state and zip. I want to have first name, last name, street address, city, state and zip extracted and put into different columns. Can this be done? |
#6
|
|||
|
|||
Seperating information in a cell
I think you added something new from your first post.... if there is a
middle initial, it is to be linked with the first name and placed in the first name column, is that correct? Three more questions... 1) Is the state name a 2-character abbreviation or is it spelled out fully? 2) Is the zip code (which I presume you want in its own column) **always** 5-digits long or could it be with the dash and additional 4 digit tacked on? 3) Is all the data separated by a commaspace as you show (except for the zip code which I presume is just separated from the state name by a single space)? Rick "andyK" wrote in message ... If there is no middle initial then nothing goes as They wanted the first name column to have either First name alone or First name than a space and then middle initial Thanks, Andy "Rick Rothstein (MVP - VB)" wrote: What do you put if there is no middle initial (like for my wife... she doesn't have a middle name)? The reason I ask is if you put nothing, then it will be hard to tell the difference between these to names (I know people with names like these)... Mary Anne Jones (Mary Anne is her full first name) Tom Della Rossa (Della Rossa is his full last name) Rick "andyK" wrote in message ... The Name is shown in each cell like the following: First Name Middle Initial Last Name (There are no commas just a space between First Middle and Last name "Rick Rothstein (MVP - VB)" wrote: How is the full name shown in the text... last namecomma first name or simple first name last name? Are there ever any middle names or titles (Mr., Mrs, Dr., etc.)? Rick "andyK" wrote in message ... What formula can be used to sepearte information in a cell and put into several cells? I exported infromation contained in a pdf file into Excel. In one of the columns each cell has a full name, Street address, City, state and zip. I want to have first name, last name, street address, city, state and zip extracted and put into different columns. Can this be done? |
Thread Tools | |
Display Modes | |
|
|