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
|
|||
|
|||
Extract portions of text
Hi,
I have a list of names comprised like this: Cook, Mr. M.S. Marty, Miss M.S.R. Constant, Mrs. R.G.L. We only have Mr., Miss and Mrs. I need to extract these into last name, title and initials: Col1 Col2 Col3 Cook Mr. M.S. Thanks for your usual cooperation |
#2
|
|||
|
|||
Extract portions of text
Hi,
use text to columns, fixed with and select where you want the columns to be "Lupe" wrote: Hi, I have a list of names comprised like this: Cook, Mr. M.S. Marty, Miss M.S.R. Constant, Mrs. R.G.L. We only have Mr., Miss and Mrs. I need to extract these into last name, title and initials: Col1 Col2 Col3 Cook Mr. M.S. Thanks for your usual cooperation |
#3
|
|||
|
|||
Extract portions of text
From menu
DataText to Columns'Delimited'SpaceNextFinish -- Jacob "Lupe" wrote: Hi, I have a list of names comprised like this: Cook, Mr. M.S. Marty, Miss M.S.R. Constant, Mrs. R.G.L. We only have Mr., Miss and Mrs. I need to extract these into last name, title and initials: Col1 Col2 Col3 Cook Mr. M.S. Thanks for your usual cooperation |
Thread Tools | |
Display Modes | |
|
|