separating cells with text

M

mikeyVo

if i have a cell that displays lastname, firstname how do i split that
text into two different columns (i.e last name in column one and first
name in column 2)? Thanks for your help
 
G

Guest

Data > TextToColumns > using comma as the delimiter.........

Vaya con Dios,
Chuck, CABGx3
 

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

Getting a message box program to run (Page 43 of 'BeginningProgramming with VBA' by Duane Birnham) 11
splitting out cell contents 2
Separate cell text FirstnameLastname into two columns 3
Split text string using mid-search? 3
Identify Duplicates that are not identical 4
Separating names 2
Text to columns. Only the first column appears in the wizard. 4
Separating carriage return data into separate cells 2

Top