View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
JBird11002 JBird11002 is offline
external usenet poster
 
Posts: 2
Default Chg 1 "Last, First Mid" column to 3 "First", "Middle", "Last"

THANKS A LOT. You don't know how much you helped. I am a recruiter and I just
shared your helpful information to hundreds of other recruiters.

"Teethless mama" wrote:

Data Text to Columns Delimited Finish

"JBird11002" wrote:

Make formatted name in one column from "last, first MI" to three seperate
columns of: 1st col-First name"first", 2nd col-Middle"middleOrMI" and 3rd
col-Last name"last". When you have a file with several rows of names you
would like to do this to, how do you do it? Going through it individual row
by row would be time consuming and monotonous.