Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need Text to Columns Help! First Name MI Last Name
Hi everyone,
I have a column of proper names, some of which have middle initials and some of which do not. I am trying to get them into columns of | first name | MI | Last Name |. The problem is that excel seperates them into three columns with the last name in the middle column for people without middle initials, and the last name in the third column for people with middle initials. I would appreciate any help you excel experts could give me. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need Text to Columns Help! First Name MI Last Name
See if the information on Chip's page here will help
http://www.cpearson.com/excel/FirstLast.htm -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 wrote in message oups.com... Hi everyone, I have a column of proper names, some of which have middle initials and some of which do not. I am trying to get them into columns of | first name | MI | Last Name |. The problem is that excel seperates them into three columns with the last name in the middle column for people without middle initials, and the last name in the third column for people with middle initials. I would appreciate any help you excel experts could give me. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need Text to Columns Help! First Name MI Last Name
one way would be to look for the . and then use the LEFT MID & RIGHT
functions. -- Don Guillett SalesAid Software wrote in message oups.com... Hi everyone, I have a column of proper names, some of which have middle initials and some of which do not. I am trying to get them into columns of | first name | MI | Last Name |. The problem is that excel seperates them into three columns with the last name in the middle column for people without middle initials, and the last name in the third column for people with middle initials. I would appreciate any help you excel experts could give me. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need Text to Columns Help! First Name MI Last Name
hit the key too quick. This will get the first name for col B. Surely, you
can figure it out for the middle initial for col C and the last name for col D. =IF(ISERR(FIND(".",A8)),LEFT(A7,FIND(" ",A8)),LEFT(A8,FIND(".",A8)-3)) -- Don Guillett SalesAid Software wrote in message oups.com... Hi everyone, I have a column of proper names, some of which have middle initials and some of which do not. I am trying to get them into columns of | first name | MI | Last Name |. The problem is that excel seperates them into three columns with the last name in the middle column for people without middle initials, and the last name in the third column for people with middle initials. I would appreciate any help you excel experts could give me. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Thanks for the help
problem solved, thanks alot. The office manager here was telling me
that it was impossible, and I was like "umm . . . no, Im going on google groups" you guys proved me right |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Thanks for the help
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I unwrap text to columns? | Excel Discussion (Misc queries) | |||
Text to columns - one way street? | Excel Discussion (Misc queries) | |||
How do I convert from text to columns automatically on import? | Excel Discussion (Misc queries) | |||
comparing columns of text (cross-searching) | Excel Discussion (Misc queries) | |||
Text to columns | Excel Discussion (Misc queries) |