Extract portions of text

L

Lupe

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
 
E

Eduardo

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extracting and replacing the first word in a String of text 5
Text to Columns help 8
Challenge: Copy across surname 2
Extract strings intelligently from single cell 0
Contains or Includes 10
Splitting cells with significant variances from row to row 2
Selecting last word in a string 3
Adding Text from seperate columns 2

Top