Excel - 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

  Eduardo replied to Lupe

Hi,
use text to columns, fixed with and select where you want the columns to be

  Jacob Skaria replied to Lupe

From menu
Data>Text to Columns>'Delimited'>Space>Next>Finish

--
Jacob

Change default comment format Excel I do not want initials ever at the beginning of comments on an Excel 2007 spreadsheet. This should not be did in Excel for Windows 3.X, which says a lot about Microsoft programming. Removing initials from "personalize your copy of Excel" does not work as Excel ignores this and recreates the initials. Stripping the author's name from the spreadsheet metadata does not work. Worse Excel insists those initials be in Bold face. Short of writing a macro is there a simple way to get rid of comment initials completely and forever? Excel Discussions Excel 2007 (1) Macro (1) RegardsDave (1) Windows (1) Hawley (1) Recreates (1) Initials (1) Metadata (1) The only way I know of is replace your initials with a Space in Excel Options username. - - Regards Dave Hawley www.ozgrid.com Debra Dalgleish com / xlcomments03.html#Plain - - Dave Peterson Using a space does not work, Excel replaces the initials. I do not understand why a complex macro is required to accomplish so simple a

diary) A9:F9 (and other rows) is the info I want with the employee's initials in G9 There are multiple entries for the employee so he may reappear in row sheets into a separate workbook Thanks Excel Worksheet Discussions Excel (1) Workbook (1) ReplyWhat (1) Initials (1) Pertains (1) Month (1) Diary (1) Day (1) What is the name of the workbook"? And in what sheet of this data that pertains to that one employee whose initials are in G9? G9 of what sheet? Otto Hi Otto, thanks for the reply What to BOB Do you want only that data that pertains to that one employee whose initials are in G9? Yes :) (G9 or generally somewhere in the G column) G9 of what asked you " Do you want only that data that pertains to that one employee whose initials are in G9?" You answered " Yes :) (G9 or generally somewhere in the G column)". Excel diary) A9:F9 (and other rows) is the info I want with the employee's initials in G9 There are multiple entries for t

adjacent cell is blank? Excel Hi all, I have a spreadsheet with several different employee initials in one cell and sometimes assistant name in the next cell if someone helped them help would be appreciated! Excel Miscellaneous Discussions SUMPRODUCT (1) HiWith (1) Gsnu201001 (1) Assistants (1) Initials (1) IFBLANK (1) Gieve (1) Hi With Employee initials in column A, assistants in column B, and BP (the employee to calculate total for adjacent, cell, is, blank? description: Hi all, I have a spreadsheet with several different employee initials in one cell and sometimes assistant name in the next cell if someone helped them

B14 and return and X in cell B15 if consequtive cells of 4 or more initials are found e.g. if B1:B2:B3:B4 = TT in each cell then the B2:B3 = TT and B4 = NN then no X is returned (cells will either contain initials or be blank) is this possible? - - Barny Excel New Users Discussions SUMPRODUCT (1) COUNTA (1 the formula is possible) -aim is to identify where there is 4 consecutive rows of initials between A1:A14 but ignoring blank cells: blank A9toA14 = blank then result = X because in this sequence (A1:A8) there is still a row of consecutive initials A4:A8 (ignoring blank A5) sorry if this isnt clear - - Barny keywords: Count, matching, data

spreadsheet: col A contains last names col B contains first names col C contains middle initials col D contains suffixes (for example, JR, SR, III, etc). When I save the spreadsheet text-editor, the columnar-formatting is lost (i.e., the last names, first names, middle initials and suffixes are no longer in columns). How can I save the spreadsheet as a columnar- formatting? Excel Programming Discussions Excel (1) TEXT (1) SR (1) Excel spreadsheet (1) Middle initials (1) Suffixes (1) Try saving as .CSV and you will see with commas between. keywords spreadsheet: col A contains last names col B contains first names col C contains middle initials col D contains suffixes (for example, JR, SR