Separating First and Last Names from 1 Cell into 2 Cells

T

thad

Hi All,

I have a list of names in an Excel Spreadsheet listed like
so:

Warner, Kurt
Faulk, Marshall

How would I use a formula or VBA to split the players
first name into one cell and their last name into another
cell.
 

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

Integrating information from Word to Excel (not mail merge) 1
Grouping Names in Mail Merge 0
Merging from an Excel file with graphics 1
Split cells next to 1 cell 1
Excel does not accept text format! 0
Excel help separating / 3
Drop down list control value in vba 2
Need help modifying code 0

Top