Edit/Replace to seperate text in columns

D

Donna

I currently have

John A Doe Sr.

I want John A in Column A and Doe in Column B. I have attempted to do the
split by:
Duplicating the entire full name in two columns. In the first column I
edit/replace by using the <space>* command replacing with a blank and the
first name is what is left. However, it does not allow me to
<space>*<space>* to gather the middle initial as well.

What else can I do in order to have the First Name and Middle initial in
Column A and Last Name and possible suffix in Column B
 

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

Make elements in a row space between instead of wrapping when choosing multiple columns 0
complicated text to column 4
Drop down lists in seperate columns 5
Setting column width in a table with a macro is not working 0
Two columns followed by single page-width column on same page 0
Formating bolded text exclusively. 0
Disable Outlook AutoCorrect with GPO 0
Use a variable in a ShapeRange.Increment 0

Top